What is trigger and different types of Triggers?

0 Answers   QuestPond,

---

What is the main difference between ‘between’ and ‘in’ condition operators?

0 Answers  

---

About types of indexes in SQL server ?

2 Answers   Cognizant,

---

Explain transaction server implicit?

0 Answers  

---

what is integrated security (SSPI). why we use in the connection string?

2 Answers  

---

---

How to defragment table indexes?

0 Answers  

---

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

0 Answers  

---

What functions can a view be used to performed?

0 Answers  

---

What happens if ntwdblib.dll is missing on your machine?

0 Answers  

---

Tell me what is normalization? Explain different forms of normalization?

0 Answers  

---

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

15 Answers   Cognizant, CTS,

---

How to get the count of distinct records. Please give me the query?

8 Answers   Value Labs,

---