RETRIEVE THE PROPERTIES OF OBJECTS IN MSSQL 2005

If you have access to SQL Server Enterprise Manager, open the database you need and examine the tables whose names begin with 'sys' (e.g. sysobjects) until you find what you need. Enterprise Manager gives you the ability to construct queries which you can then copy and use again later if you need.

To access EM the command should be something like -
C:\WINDOWS\system32\mmc.exe /s "C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC"

The question looks to be abandoned by the user who asked it. If no action is taken within 2 days, a Quomon Moderator will consider closing the question and distributing the points.

The Quomon Team

If you have access to SQL Server Enterprise Manager, open the database you need and examine the tables whose names begin with 'sys' (e.g. sysobjects) until you find what you need.

http://www.neu92.com/

The above message is spam!