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
Is there any difference between the primary key and unique key?
What are click through reports?
What is the contrast amongst drop and truncate?
How can I change procedure name in sql server?
How to disable triggers using "disable trigger"?
What is 3nf normalization?
What are ddl (data definition language) statements for tables in ms sql server?
How to override dml statements with triggers?
Can we use pragma autonomous_transaction in trigger?
Explain query editor regions
Can you pass expressions to function parameters?
What is nolock?
what are cursors? : Sql server database administration
Mention the uses of stored procedures.
What is user-defined function?