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 are the differences between local and global temporary tables?
What is storeprocedure?Tell me synatx for how to write stored procedure.
what is a stored procedure and trigger?
how can i view structure of table in sql server? tell me that query.
Explain how dts is used to extract, transform and consolidate data?
What is the best way to move n number of DTS package from one SQLServer to another SQLServer?
Describe in brief databases and sql server databases architecture.
Where are magic tables stored ? Is it in the same database where it is created ?
How many types of Cursor in SQL SERVER?
How to find the date and time of last updated table?
How to link up the text file to a Database table?
What is system stored procedures?
Oracle (3253)
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)