SQL Server Management Studio (SSMS)
SQL Server 2005 introduced the new SQL Server Management Studio (SSMS). When compared with the Enterprise Manager, which was used in earlier versions of SQL Server, the SSMS interface provides many enhancements. Much like the Enterprise Manager, the vast majority of actions taken in SSMS are really just calls to the database engine using Transact-SQL code. At least two benefits arise from this architecture.
First, you can learn to automate administrative tasks by capturing the actions when a Script button is not available or by viewing the code directly when a Script button is available. Second, you can discover which settings are stored in the Registry (and some still are) and which settings are stored in ...
Get SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond 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.
