Encrytpion on SQL Server 2008
I want to encrypt a stored procedure in SQL Server 2008. I tried software such as SQL shield, it's great but the problem is SQL Profiler can still record/log the content of my original SP. Is there any way to avoid SQL Profiler from recording/logging my original content? If not, do you suggest any different software that could encrypt the SP at my PC, and deliver the encrypted SP to my client's server?
Software/Hardware used:
Software/Hardware used:
ASKED:
March 2, 2010 4:55 PM
UPDATED:
March 3, 2010 5:26 AM
RELATED QUESTIONS
- SQl Server 2008 Plain Text procedures results iin Encrypted Text within Profiler
- Deleted files reappear after logging on Windows Server 2008
- What security token is used when using UNC path remotely under domain admin context?
- Problem with roaming profiles in Windows server 2003
- OWA deleting emails 1 user affected
Answer Wiki:
Use the WITH ENCRYPTION flag. Keep in mind that it takes all of about two seconds to decrypt stored procedures within SQL Server.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
