what is difference between Enterprise Manager and Query Analyer

Categories >> Software >> Databases >> SQL Server
Suggest New Category

what is difference between Enterprise Manager and Query
Analyer

Question Posted / vrajkumarmca

6 Answers
8139 Views
CTS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is difference between Enterprise Manager and Query Analyer..

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

what is difference between Enterprise Manager and Query Analyer..

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

what is difference between Enterprise Manager and Query Analyer..

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

what is difference between Enterprise Manager and Query Analyer..

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 difference between Enterprise Manager and Query Analyer..

Answer / vrajkumarmca

SQL Server

Is This Answer Correct ?

3 Yes

3 No

what is difference between Enterprise Manager and Query Analyer..

Answer / harshal vidhut

spelling are different.....

Is This Answer Correct ?

3 Yes

12 No

Post New Answer