what is difference between Enterprise Manager and Query
Analyer
Answer Posted / ramesh ummadisetty
In sql server 2008 we have Enterprise Manager. Here we can create database, tables, stored procedures 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
Can you name some of the dml commands in sql?
State the difference between local and global temporary tables?
What is 2nf normalization?
Explain the functionalities that views support?
What is truncate table?
What is the difference between a clustered index and a non-clustered index?
What is transaction server distributed transaction?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
How can you find out how many rows returned in a cursor?
explain what is raid and what are different types of raid configurations? : Sql server database administration
How many replicas are maintained for each SQL Azure database?
What is inline variable assignment?
Explain the third normal form(3nf)?
Define outer join?
What is extent? Types of extents?