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
What is tcl in sql server?
What are the different types of join?
What is difference between view and materialized view?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What is the difference between clustered and a non-clustered index?
What is the difference between count and distinct count?
How to create a login account in ms sql server to access the database engine using "create login" statements?
How to run queries with sql server management studio express?
how many bits ip address consist of? : Sql server database administration
Which sql server table is used to hold the stored procedure scripts?
Which are the important points to note when multilanguage data is stored in a table?
Explain what role entity and relationship play in an ER diagram.
Can you roll back the ddl statement in a trigger?
How to create function without parameter in sql server?
What is the boxing and unboxing concept in .net?