what is difference between Enterprise Manager and Query
Analyer
Answer Posted / 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 |
Post New Answer View All Answers
Tell me the difference between clustered and non-clustered index?
How to include date and time values in sql statements?
What is the purpose of optimization?
How to Check if table exists in sql server?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
What are the components of sql server service broker?
Explain time data type in sal server 2008?
What is store procedure?
How to disconnect from a sql server using mssql_close()?
What is the difference between cartesian product and cross join?
What is a trace frag? Where do we use it?
What are constraints?
What is filestream?
Explain linked server in sql?
What is sql server 2000 work load governor?