Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between Enterprise Manager and Query
Analyer
- 6 Answers
- 9359 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are data driven subscriptions?
A trigger can reference objects outside the current database? State true or false.
How to set database to be read_only in ms sql server?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
What's the information that can be stored inside a bit column?
What is dbcc command in sql server?
How to use “drop” keyword in sql server and give an example?
What is a deadlock and what is a live lock?
Why we use trigger in sql server with example?
What is the purpose of a table?
Do you know how to store and query spatial data?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
How to use "begin ... End" statement structures in ms sql server?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
What are data regions?
