Database Information Script
-
Hi All
I need to spool into a file the following information from all my SQL server instances:
Kindly let me have a script that can do this including specifying how to spool this information into a file:
spool the following information to a named file
print Database Information
print
print
print
print Database Name
print -------------------------------------
script
print
print Databases - Tablespaces/files
print -------------------------------------
script
print
print Databases - Links
print -------------------------------------
script
print
print Databases - Accounts
print ------------------------------------
script
print
print Databases - Tables by Accounts
print -------------------------------------------
script
print
print Databases - Columns by Tables
print -------------------------------------------
script
print
print Databases - Views by Accounts
print -------------------------------------------
script
print
print Databases - Indexes by Accounts
print -------------------------------------------
script
print
print Databases - Constraints by Accounts
print -------------------------------------------
script
print
print Databases - Sequences by Accounts
print -------------------------------------------
script
print
print Databases - Synonyms by Accounts
print -------------------------------------------
script
exit;
EOF
*** An urgent responce will be appreciated.
Cheers
Jesuseun
-
please don't multiple post
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply