what is difference between Enterprise Manager and Query
Analyer
Answers were Sorted based on User's Feedback
Answer / saomya jha
Anything development related should be done in Query
Analyser. Many Management related tasks are better handled
in Enterprise Manager.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / ramesh ummadisetty
In sql server 2008 we have Enterprise Manager. Here we can create database, tables, stored procedures etc.
In Query Analyser we can write the queries and execute them.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ramesh ummadisetty
Typing mistake in the above answer:
In sql server 2000 we have Enterprise Manager to manage sql server databases. Here we can create database, tables, stored procedures, permissions etc.
In Query Analyser we can write the queries and execute them.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / samba shiva reddy m
SQL Server Enterprise Manager is like user interface,
To do the all things like creating db ....etc.
SQL Server Query Analyser is command prompt.we have to write query and execute it.
Is This Answer Correct ? | 1 Yes | 0 No |
what is database replicaion? : Sql server database administration
What is RMS migrations?
How much does sql server 2016 cost?
What is a heap?
How do SQL server 2000 and XML linked?
What are partitioned views?
What is difference between materialized view and view?
What is difference between commit and rollback when used in transactions?
Explain about extended stored procedure?
Which command is used for user defined error messages?
What is SubQuery in SQL Server 2008
What is log ldf?