Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between Enterprise Manager and Query
Analyer
- 6 Answers
- 9628 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / saomya jha
Anything development related should be done in Query
Analyser. Many Management related tasks are better handled
in Enterprise Manager.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / ramesh ummadisetty
In sql server 2008 we have Enterprise Manager. Here we can create database, tables, stored procedures etc.
In Query Analyser we can write the queries and execute them.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ramesh ummadisetty
Typing mistake in the above answer:
In sql server 2000 we have Enterprise Manager to manage sql server databases. Here we can create database, tables, stored procedures, permissions etc.
In Query Analyser we can write the queries and execute them.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / samba shiva reddy m
SQL Server Enterprise Manager is like user interface,
To do the all things like creating db ....etc.
SQL Server Query Analyser is command prompt.we have to write query and execute it.
| Is This Answer Correct ? | 1 Yes | 0 No |
what is difference between view and Dip.
What is subquery in sql?
Explain about remote stored procedure?
what is a transaction? : Sql server database administration
Can XML be used to access data?
Explain an automatic checkpoint
What is sql stored procedure?
Write a code to select distinct records without using the DISTINCT keyword.
What is the server name in sql server?
How to create a simple stored procedure in ms sql server?
Explain “@@rowcount” and “@@error” in sql server?
How will you go about resolving deadlocks?
-
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)
