what is difference between Enterprise Manager and Query
Analyer

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

More SQL Server Interview Questions

What is the difference between having and where clause?

4 Answers  


how to implement locking in sql server

3 Answers   Satyam,


What is sql stored procedure?

0 Answers  


What is data source object?

0 Answers  


Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 Answers  






What is temporal data type?

0 Answers  


How you trouble shoot when any job fails

0 Answers  


what are batch in sql server?

2 Answers   Satyam,


Tell me about Triggers?

3 Answers   Cap Gemini,


Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz

3 Answers  


What should be the fill factor for indexes created on tables? : sql server database administration

0 Answers  


What is a sql join?

0 Answers  


Categories