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 |
Does union all remove duplicates?
 Explain what is sql override for a source taLle in a mapping?
Explain primary key in sql server?
Explain the use of keyword with encryption. Create a store procedure with encryption?
What is a transact-sql statement batch in ms sql server?
How to change the password of a login name in ms sql server?
What is indexing?
How to get a list of columns in a view using "sys.columns" in ms sql server?
What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?
2 Answers Accenture, Merrill Lynch, Wipro,
How to delete an attribute from the emp table
how to find number of columns in a table in sql server 2000 and 2005 also
If we use where clause in the left outer join then how the query would behave/act?
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)