what is difference between Enterprise Manager and Query
Analyer
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 the difference between having and where clause?
how to implement locking in sql server
What is sql stored procedure?
What is data source object?
Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance
What is temporal data type?
How you trouble shoot when any job fails
what are batch in sql server?
Tell me about Triggers?
Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz
What should be the fill factor for indexes created on tables? : sql server database administration
What is a sql join?