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.
| Author |
Topic |
|
daksri
Starting Member
6 Posts |
 Posted - 2007-04-18 : 13:07:24
|
| Hi:I am a Sql server 8.0 user,and using query analyser extensively. Is the query analyser available in SQL sever 2005 version ?thank you in advance. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-04-18 : 13:09:36
|
No not available in 2005. You can use SQL Server Management Studio to run your query.
KH |
 |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-04-18 : 13:10:29
|
| Ofcourse its available. Its caled Management Studio (MS). When you open MS, Under the Object Explorer, right click on any DB -> New Query. If you have nto registered any servers, you might need to do so.************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-04-18 : 13:14:04
|
If you are a die-hard fan of Query Analyser you can still use it to connect to SQL Server 2005 
KH |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2007-04-18 : 13:55:54
|
| This is the same as what I have heard,I am currently studying for MCP's in sql 2000 and was worried about not being able to use the query analyzer but having seen the management studio it seems like a posh word for something that just seems to incoporates the query analyzer and enterprise manager into one package, I’m sure it wont take long to work out the diffrences and where things are... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-18 : 16:02:25
|
| Should go for MCTS sql2k5 instead. |
|
|
|
|
|
|
Query Analyser in 2005 ?