Question

  Asked: May 12 2008   7:50 AM GMT
  Asked by: Subrata73


how to get list of encrypted objets in sqlserver 2005?


SQL Server 2005, Encrypted stored procedures, Encrypted triggers

i need a list of encrypted store procedure name,encrypted trigger ,encrypted functions from sql server 2005.

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



You can query from the sys.sql_modules DMV. If the definition is null then it's encrypted.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on SQL Server and Database.

Looking for relevant SQL Server Whitepapers? Visit the SearchSQLServer.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Mrdenny  |   May 14 2008  8:32AM GMT

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.