List of Approved Assemblies

Where is it documented what the list of approved assemblies are for SQL 2005. Also, is there a way via T-SQL, or other means to get it programatically?Didi you already try to query te system table sys.assemblies ?

Select * from sys.assemblies

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||That doesn't get you "approved" assemblies, that just lists the assemblies that have been loaded to the DB using the CREATE ASSEMBLY command.

I'm looking for the list of "Approved Assemblies".|||

Here's a link to BOL that provides this information:

http://msdn2.microsoft.com/en-us/library/ms403279.aspx

Steven