Answer / Nisar Ahmad

Database states in MS SQL Server include:n- Running: The database is available for connections.n- Restoring: The database is being restored.n- Offline (single user mode): The database can be accessed by a single user, useful for repairing or recovering data.n- Recovery pending: The database is in the process of recovery after an outage.n- Suspect: The database has encountered errors and needs to be checked and possibly repaired.

Where is trigger in sql server?

1 Answers  

---

Why use “nolock” in sql server?

1 Answers  

---

Why we use trigger in sql server with example?

1 Answers  

---

Find columns used in stored procedure?

1 Answers  

---

What is difference between inner join and full join?

1 Answers  

---

What is rank function?

1 Answers  

---

What is the maximum size per database for sql server express?

1 Answers  

---

but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

1 Answers  

---

how to retrive only second row from table in sql server 2000?

15 Answers   Cognizant, CTS,

---

What is tempdb database? : SQL Server Architecture

1 Answers  

---

What is stored in the mssqlsystemresource database? : sql server database administration

1 Answers  

---

What is the need for group functions in sql?

1 Answers  

---