Lost in SQL 2k5 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Lost in SQL 2k5

Author

Topic

JacobPressures
Posting Yak Master

112 Posts

Posted - 2008-09-18 : 17:54:48

I just installed SS2005 and I'm lost. I'm used to using ss2000. I'm looking for Query Analyzer and Enterprise Manager.

I did all my coding in QA but if i wanted to check my tables quickly i would go to EM with a few clicks. Is it under SQL Server Configuration Manager now? I don't see the master table or anything.

Are all my SS2000 books going to be useless?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-09-18 : 17:56:09

The replacement to both is Management Studio, although you can still use Query Analyzer with 2005 servers. You can't use Enterprise Manager with 2005 servers though.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

lepeniotis
Yak Posting Veteran

75 Posts

Posted - 2008-09-19 : 04:02:35

The books are never useless!! The main core is the same! The master DB you can see it by clicking the databases then click system Databases. You can still use these books but have a look at these two sites which are part 1 on http://www.sqlservercentral.com/articles/Administration/2988/ and part 2 on http://www.sqlservercentral.com/articles/News/3036/

Regards

MSc Advanced Computing Science
MSc Database Professional
Sheffield Hallam University
MCP (70-229, 70-228)
Industrial IT Engineer

JacobPressures
Posting Yak Master

112 Posts

Posted - 2008-09-22 : 15:52:27

I've read over the articles. Thanks!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources