Answer / guest

4 key default dbs :-
Master db : Holds info of all dbs located on SQL Server
insytance. Main db (else SQL Server won't work !)
MSdb : Stores info regarding Backups, SQL Agent info, DTS
packages, SQL Server jobs, replication info for log
shipping.
Tempdb : To hold temp objects like global & local temp
tables, sps
Model db: Used in creation of any new database within the
SQL Server instance of which it(model) is a part.

Answer / hari

In 2005 .newly implemented Resource Db

what is difference between Enterprise Manager and Query Analyer

6 Answers   CTS,

---

Is sql different from sql server?

0 Answers  

---

How to add additional conditions in SQL?

0 Answers   Amdocs,

---

How do I shrink an ldf file?

0 Answers  

---

what is cursor?why we will go to cursor?advantages &disadvantages of cursors?

1 Answers  

---

---

What are character string data types in ms sql server?

0 Answers  

---

Do you know how to make remote connection in database?

0 Answers  

---

How to disable triggers using "disable trigger"?

0 Answers  

---

Explain features of analysis services?

0 Answers  

---

how to delete duplicate rows from table

9 Answers   CSC,

---

What are the types of sql server?

0 Answers  

---

i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 Answers  

---