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.

Export SQL server Diagram.

Can I export SQL server diagram into VISIO?
I found an article that saves dtproperties table to export diagram. I don't
know if you can import the DTS package into VISIO or not.No, you can't do that... ( MS is usually so good at integration of its
products, but this is one place there is no integration.)
Probably the best thing to do is simply reverse engineer the db using
Visio,,, You'll get what you need quickly.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"strout" <strout@.discussions.microsoft.com> wrote in message
news:C434DCA6-68BF-4A28-9DC4-C6D1C005B3C0@.microsoft.com...
> Can I export SQL server diagram into VISIO?
> I found an article that saves dtproperties table to export diagram. I
> don't
> know if you can import the DTS package into VISIO or not.
>

export SQL diagrams

How do you export SQL diagrams to say, Visio? More
importantly, can it be done? Thanks.
- Rob.
Yes and no. You cannot export the SQL diagram from Enterprise Mangler to
Visio. You can have Visio connect to your database and generate its own
diagram. Here is a link for step-by-step instructions:
http://office.microsoft.com/en-us/as...181821033.aspx
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:076001c4f812$6dda2850$a601280a@.phx.gbl...
> How do you export SQL diagrams to say, Visio? More
> importantly, can it be done? Thanks.
> - Rob.

export SQL diagrams

How do you export SQL diagrams to say, Visio? More
importantly, can it be done? Thanks.
- Rob.Yes and no. You cannot export the SQL diagram from Enterprise Mangler to
Visio. You can have Visio connect to your database and generate its own
diagram. Here is a link for step-by-step instructions:
http://office.microsoft.com/en-us/assistance/HP010181821033.aspx
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:076001c4f812$6dda2850$a601280a@.phx.gbl...
> How do you export SQL diagrams to say, Visio? More
> importantly, can it be done? Thanks.
> - Rob.

export SQL diagrams

How do you export SQL diagrams to say, Visio? More
importantly, can it be done? Thanks.
- Rob.Yes and no. You cannot export the SQL diagram from Enterprise Mangler to
Visio. You can have visio connect to your database and generate its own
diagram. Here is a link for step-by-step instructions:
http://office.microsoft.com/en-us/a...0181821033.aspx
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:076001c4f812$6dda2850$a601280a@.phx.gbl...
> How do you export SQL diagrams to say, Visio? More
> importantly, can it be done? Thanks.
> - Rob.