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


Please Help Members By Posting Answers For Below Questions

What the different components in replication and what is their use?

707


Explain log shipping and mention its advantages.

780


What is the process of indexing?

705


What is the cpu pressure?

762


What is default port number for sql server 2000?

749






Determine how to use the inserted and deleted pseudo tables?

725


What do you mean by cardinality?

650


Tell me what is normalization? Explain different forms of normalization?

762


how to overcome kernel isssues

1349


What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

783


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

1713


what is a correlated sub-query? : Sql server database administration

672


How to loop through result set objects using mssql_fetch_array()?

748


What is update_statistics command?

761


What is normalization process?

795