Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between Enterprise Manager and Query
Analyer
- 6 Answers
- 9613 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 stored procedure would you use to view lock information? : Sql server administration
statement (of account) Receive ID_receive Date_receive Amount_receive TO_receive From_receive Description_receive 1 2010/01/01 500 Bank Ahmed Payment from the account 2 2010/02/01 700 Bank Ahmed Payment from the account Payment ID_payment Date_payment Amount_payment From_payment To_payment Description_payment 1 2010/03/01 1000 Ahmed Sales Sale goods 2 2010/04/01 1500 Ahmed Sales Sale goods How can crate Stored Procedures for the statement (of account) from these tables? I want statement (of account) like this: (in sql 2005) ID_ name description debit account credit account balance
What is the use of builtinadministrators group in sql server? : sql server security
What are the 2 types of classifications of constraints in the sql server?
What do we need queues in sql service broker?
What are the 7 disadvantages to a manual system?
What is the Difference Between Primary and Foreign Key?
0 Answers Accenture, Deloitte, JPMorgan Chase, Maveric,
What is MSDE?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
What do you understand by hotfixes and patches in sql server?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
What area unit the various kinds of info compression introduced in sql server 2008?
-
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)
