|
Home > Archive > Microsoft SQL Server forum > March 2005 > Specific Book Recommendation
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Specific Book Recommendation
|
|
| python1 2005-03-30, 7:04 pm |
| 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?
| |
| Simon Hayes 2005-03-31, 7:01 am |
| 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
| |
| python1 2005-03-31, 8:03 pm |
| 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.
|
|
|
|
|