I asked the question Is there a quick way to find all columns in SQL Server 2008 R2 that are encrypted/have encrypted data on Stack Exchange and got a couple of great responses that pointed to "no" but someone came through with the answer and it worked. Basically you have to use the KEY_NAME() function and loop through the system tables to get what you need.
I won't go into great detail here since it's all in the web page linked above.
No comments:
Post a Comment