Answer / saomya jha

Anything development related should be done in Query
Analyser. Many Management related tasks are better handled
in Enterprise Manager.

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.

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.

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.

Answer / vrajkumarmca

SQL Server

Answer / harshal vidhut

spelling are different.....

What number aggregate functions are accessible there in sql?

0 Answers  

What does normalization do to data?

0 Answers  

Differences between Standby Vs No recovery?

2 Answers   Wipro,

A trigger can reference objects outside the current database? State true or false.

0 Answers  

What is sql server schema compare? How we can compare two database schemas?

0 Answers  

Observed that some SP’s / Jobs are processing late, how to troubleshoot to improve performance?

1 Answers  

Is it possible in sql table to have more than one foreign key?

0 Answers  

What is Index Segmentation ?

1 Answers   TCS,

what is Equity join?

2 Answers   ADP,

How do I know if localdb is running?

0 Answers  

Explain index in sql server?

0 Answers  

Explain what is the difference between union and union all?

0 Answers