Tuesday, March 27, 2012

DB and tables usage information

Hi everybody!
Using SQL Server Enterprise Manager I can see general
information about DB, tables and indexes (Right click
over DB name and See option)
How can I print this information? or export it? Is there
any store procedure to get this information?
Thanks for your help.
LJ.Hi
Check out sp_help, sp_helpdb, sp_helptext in books online.
John
"LJ" <leyla.garcia@.unisabana.edu.co> wrote in message
news:07c901c34249$f638cfb0$a001280a@.phx.gbl...
> Hi everybody!
> Using SQL Server Enterprise Manager I can see general
> information about DB, tables and indexes (Right click
> over DB name and See option)
> How can I print this information? or export it? Is there
> any store procedure to get this information?
> Thanks for your help.
> LJ.sql

No comments:

Post a Comment