April 18, 2005 at 7:52 am
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 Database Name
print -------------------------------------
script
print Databases - Tablespaces/files
print -------------------------------------
script
print Databases - Links
print -------------------------------------
script
print Databases - Accounts
print ------------------------------------
script
print Databases - Tables by Accounts
print -------------------------------------------
script
print Databases - Columns by Tables
print -------------------------------------------
script
print Databases - Views by Accounts
print -------------------------------------------
script
print Databases - Indexes by Accounts
print -------------------------------------------
script
print Databases - Constraints by Accounts
print -------------------------------------------
script
print Databases - Sequences by Accounts
print -------------------------------------------
script
print Databases - Synonyms by Accounts
print -------------------------------------------
script
exit;
EOF
*** An urgent responce will be appreciated.
Cheers
Jesuseun
April 18, 2005 at 8:29 am
Books on line might be a good starting point.
Output from a query can be output to a file through QA or dts
[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