what is difference between Enterprise Manager and Query
Analyer
- 6 Answers
- 8140 Views
- CTS, I also Faced
- E-Mail Answers
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
How to sort query output in descending order in ms sql server?
What are different types of data sources?
How will you know when statistics on a table are obsolete?
Difference between Inner vs outer joins?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
What is filter index?
What are joins in sql and what are the different types of joins?
How to create a user name in a database?
Can a trigger be created on a view?
You want to implement the one-to-one relationship while designing tables. How would you do it?
Difference between report and query parameter.
Can two tables share a primary key?
What are scheduled tasks in sql server?
What is a domain constraint give an example?
What is Command line parameters in PLSQL.?
