Export System Catalog info

Hello,

I'm looking for a solution that will the extraction of system catalog information into either Excel or visio. We are looking to do this for documentation purposes. Is there a way to do this on the fly or do I need to run a view and then copy and past the information.

use sql Scripting. If the instance is SQL 2005 , then SQLCMD and if it is 2000 then OSQL.

SQL 2005 - sqlcmd -q"Exec sp_who2" -o"sp_who2_as_on_date.text"

SQL Server 2000- OSQL -q"Exec sp_who2" -o"sp_who2_as_on_date.text"

Check this

Madhu

|||If not you can set the query editor on SSMS to post the results to file by stating to comma seperated values.