470,614 Members | 1,429 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,614 developers. It's quick & easy.

Specific Book Recommendation

I would like to locate a book that focuses on MSSQL administration from
the command line. My background is in Informix, and I am used to doing
things from the prompt.

Any recommendations?
Jul 23 '05 #1
2 976
Books Online. It may sound obvious, but in reality most admin
interfaces to MSSQL are using TSQL - Enterprise Manager executes TSQL
behind the scenes, and so does SQLDMO.

If you're familiar with COM, you can use SQLDMO for most admin tasks,
and if not then executing TSQL commands or scripts with osql.exe will
work too. If you know how to do something in Enterprise Manager, but
not from TSQL, then you can use Profiler to trace what EM is sending to
the server and re-use that in your own scripts.

Simon

Jul 23 '05 #2
Simon Hayes wrote:
Books Online. It may sound obvious, but in reality most admin
interfaces to MSSQL are using TSQL - Enterprise Manager executes TSQL
behind the scenes, and so does SQLDMO.

If you're familiar with COM, you can use SQLDMO for most admin tasks,
and if not then executing TSQL commands or scripts with osql.exe will
work too. If you know how to do something in Enterprise Manager, but
not from TSQL, then you can use Profiler to trace what EM is sending to
the server and re-use that in your own scripts.

Simon


Thank you.
Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Phil Da Lick! | last post: by
9 posts views Thread by Reginald Blue | last post: by
16 posts views Thread by Robert Zurer | last post: by
6 posts views Thread by ted | last post: by
4 posts views Thread by Huy | last post: by
3 posts views Thread by Lauren Quantrell | last post: by
14 posts views Thread by At_sea_with_C | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.