Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between Enterprise Manager and Query
Analyer
- 6 Answers
- 9603 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 ssl in sql server?
Disadvantages of the indexes?
how do u do Performance tunning ?
1 Answers Infodat Technologies, Satyam,
What are the advantages of partitioning?
What do you understand by a view? What does the with check option clause for a view do?
What are sql servers used for?
What is the meaning of resultset type_scroll_insensitive?
Using the customer, and order table in northwind database, please write a query to produce xml?
Do you know what is similarity and difference between truncate and delete in sql?
Explain datetimeoffset data type in sal server 2008?
Questions regarding Raiseerror?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
-
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)
