what is the Enterprise manager(2000) and management studio
(2005)?
Answer Posted / maanu
Enterprise manager is a tool which comes with SQL Server 2k
and from there you can manage all the aspects of the SQL
Server 2k. But in order to write queries and T-SQL you have
to use Query Analyzer.
SQL Server Management Studio is combination of both SQL
Server Enterprise Manager + Query Analyzer of SQL 2k.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Explain log shipping?
How important do you consider cursors or while loops for a transactional database?
Why should one not prefix user stored procedures with ‘sp_’?
What are the methods used to protect against sql injection attack?
What are different types of schemas?
What is difference between order by and group by?
Can you move the resources after pausing the node? : sql server database administration
Why de-normalization required?
What is data compression?
What is 1nf 2nf?
How to count groups returned with the group by clause in ms sql server?
What are dml triggers and types of dml triggers?
How to use user defined functions in expressions?
What is sleeping status in sql server?
Explain various data region available in ssrs with their use?