what is the Enterprise manager(2000) and management studio
(2005)?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / prasad
Entere prise manager+ Query Analyzer =
Entereprise management studio
| Is This Answer Correct ? | 2 Yes | 1 No |
what is a correlated sub-query? : Sql server database administration
How to loop through returning rows?
What are the different types of replication you can set up in sql server?
What is model database in sql server?
Describe how to use linked server?
What are explicit and implicit transactions?
When do you create cluster and noncluster index?
What does it mean to have quoted_identifier on? What are the implications of having it off?
where do you use Isolations?give me some exmpale?
Explain Capacity planning to create a database? and how to monitor it?
Why I can not enter 0.001 second in date and time literals in ms sql server?
Do you know query execution plan?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)