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
application server is slow what may be the problem
How to download and install the scaled-down database adventureworkslt?
How can windows applications connect to sql servers via odbc?
What is the difference between varchar and nvarchar datatypes?
Detail about the hardware which is supported by SQL server?
How you would rewrite the sql query to return the customerid sorted numerically?
How will you optimize a stored procedure optimization?
How do you create an execution plan?
When would you use sql joins?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
Explain trigger and trigger types?
What are the built in functions in sql server?
What is ms sql server service broker?
Can the “if update (colname)” statement be used in a delete trigger?
Explain the purpose of indexes?