Introducing SQL Server 2000 Enterprise Manager

As you have just seen, the Query Analyzer is a very powerful tool. It has been greatly enhanced in SQL Server 2000 to be a SQL programmer's best friend. However, you still have the SQL Server Enterprise Manager, which is meant to be the primary graphical interface. There's very little that the Enterprise Manager can do that you can't accomplish from a T-SQL command in the Query Analyzer. However, using the Enterprise Manager is sometimes more convenient, especially when you are new to the SQL Server environment or to SQL programming.

Registering a Server

If you are using SQL Server on your computer, and it is the first time you have started the SQL Server Enterprise Manager, you might need to register ...

Get Sams Teach Yourself Transact-SQL in 21 Days, Second Edition 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.