Answer / Subash Chandra Pandey

In SQL Server 2000, the recovery models are: Full (all data and transaction log are backed up), Bulk-Logged (bulk-logged operations consume less log space than the full recovery model but provide less recovery protection), and Simple (only full backups are performed and only the most recent backup can be restored; it does not support point-in-time recovery).

How do I create a stored procedure in sql server?

1 Answers  

---

What are data files?

1 Answers  

---

In which format does an image save in SQL Server database ?

1 Answers   MCN Solutions,

---

Do you know sql server 2008 backup compression?

1 Answers  

---

Define model database?

1 Answers  

---

Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 Answers  

---

What is a bit datatype?

1 Answers  

---

How do I view a stored procedure in sql server query?

1 Answers  

---

What is similarity and difference between truncate and delete in sql?

1 Answers  

---

How to drop an existing schema in ms sql server?

1 Answers  

---

what is web server?

3 Answers   Satyam,

---

How do you send email on SQL Server?

1 Answers   MindCracker,

---