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

How to write a query with a full outer join in ms sql server?

558


Explain the difference between delete,drop and truncate in SQL Server?

589


Explain syntax for dropping triggers?

515


Name few endpoints exposed by ssrs 2012?

303


What are trace files?

532






What is data mart? : sql server analysis services, ssas

592


what's the difference between delete table and truncate table commands? : Sql server database administration

482


How to maintain a fill factor in existing indexes?

528


Can group functions be used in the order by clause in ms sql server?

586


Can sql servers linked to other servers?

545


I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

676


Can you explain important index characteristics?

520


How do I find the port number for sql server?

500


What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

590


You want to implement the many-to-many relationship while designing tables. How would you do it?

557