Home > IT Answers > Database > how to get list of encrypted objets in sqlserver 2005?
Subrata73
5 pts.
 how to get list of encrypted objets in sqlserver 2005?
Encrypted stored procedures, Encrypted triggers, SQL Server 2005
i need a list of encrypted store procedure name,encrypted trigger ,encrypted functions from sql server 2005.

Software/Hardware used:
ASKED: May 12, 2008  7:50 AM
UPDATED: May 14, 2008  8:32 AM
RELATED QUESTIONS
Answer Wiki:
You can query from the sys.sql_modules DMV. If the definition is null then it's encrypted.
Last Wiki Answer Submitted:  May 14, 2008  8:32 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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

Denny Cherry
 64,520 pts.