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
What are the different Authentication modes in SQL Server and how can you change authentication mode?
In case you have filters in your report, when filters will be applied in cached report instance?
What command do we use to rename a database?
What are the database roles? : sql server security
Some queries related to SQL
How will you hide an attribute? : sql server analysis services, ssas
What is the difference between DATETIME2 and DATETIME?
What is compound operators?
Write a sql query to get zero records from a table having n number of records?
How to remove duplicate rows from table?
Do you know what are acid properties of transaction?
What is the openxml statement in sql server?
Write the syntax for stuff function in an sql server?
Can we call future method from queueable?
What is ems sql management studio? : sql server management studio