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 field with example?

0 Answers  

---

How to round a numeric value to a specific precision?

0 Answers  

---

Explain trigger and its types?

0 Answers  

---

After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )

3 Answers   CarrizalSoft Technologies, iGate,

---

How to create function without parameter in sql server?

0 Answers  

---

---

Explain Geometry datatype in sql server 2008 with example

0 Answers   Infosys,

---

What is the difference between lock, block and deadlock? : sql server database administration

0 Answers  

---

what is the Enterprise manager(2000) and management studio (2005)?

2 Answers  

---

What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....

9 Answers   DELL, i Tech, Infosys, Siemens, TCS,

---

What is filestream?

0 Answers  

---

What happens if we shrink log file in sql server?

0 Answers  

---

How to remove duplicate rows from table except one?

0 Answers  

---