IX.B.2. How Can I Administer My Database?
A database administrator's work is never done. Fortunately, Microsoft didn't skimp on the supporting tools. Here are two good choices to get the job done quickly and easily:
SQLCMD utility: This character-based tool ships with every copy of SQL Server. You can run just about any administrative task using direct Transact-SQL or one of the hundreds of built-in system stored procedures. However, you're better served by the SQL Server Management Studio, which I describe next.
SQL Server Management Studio: If you have more of a hankering for graphical tools when it comes to administration, you want to look at this utility. You can perform just about any administrative chore you might ever face. And, whatever isn't possible can be handled with direct Transact-SQL or system stored procedures.
Get Microsoft® SQL Server™ 2008 All-In-One Desk Reference For Dummies® now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
