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
How to write a query with a full outer join in ms sql server?
Explain the difference between delete,drop and truncate in SQL Server?
Explain syntax for dropping triggers?
Name few endpoints exposed by ssrs 2012?
What are trace files?
What is data mart? : sql server analysis services, ssas
what's the difference between delete table and truncate table commands? : Sql server database administration
How to maintain a fill factor in existing indexes?
Can group functions be used in the order by clause in ms sql server?
Can sql servers linked to other servers?
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
Can you explain important index characteristics?
How do I find the port number for sql server?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
You want to implement the many-to-many relationship while designing tables. How would you do it?