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 |
|
mbevon
Starting Member
41 Posts |
 Posted - 2002-05-29 : 14:31:16
|
| When do i use a The Query analyser as oppose to the Enterprise Manager?Thanks |
|
|
yakoo
Constraint Violating Yak Guru
312 Posts |
Posted - 2002-05-29 : 14:35:12
|
| I practically use Query Analyzer all of the time to run queries, look at exectution plans. The only time I use EM is to set up a database, and to use the GUI tool to modify the table designs.Got SQL? |
 |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-05-29 : 14:52:58
|
| As a matter of principle, I believe you should never do anything with the gui that you don't know how to do in QA.<O> |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-05-29 : 15:21:33
|
and I write all my DTS packages in notepad  but seriously... EM is very useful for things like job management, setting up full text indexes, user/group management,DTS etc i.e admin workHowever I would never use it to create/alter tables/indexes/sprocs/triggers/views or do any data manipulation.Thats what QA is for. Horses for courses |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-05-29 : 19:45:16
|
| The problem with using enterprise manager is that it doesn't give you a record of what you have done.If you always use a query window then you can save the script and have a record of your actions and also be able to repeat them.This especially applies to security issues.My opinion - use e-m for information only - never use it for making changes.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Query Analyser & Enterprise manager