Answer Posted / pavan singh

there are 5types of isolation level
1.ecoas
2.read commited
3.read uncommited
4.repetable read
5.synchronized

What are the limitations in ssrs on sql server express edition?

189

---

What are the authentication modes in sql server? How can it be changed?

1140

---

Explain what stored procedure sp_replcounters is used for? : sql server replication

1532

---

Does group by sort data?

909

---

What is the function of sql server agent windows service?

1104

---

What is the return type of executeupdate ()?

914

---

Can I run multiple instances of sql server 2000 at the same time on one computer?

1085

---

Tell me what is difference between clustered and non clustered index?

951

---

What happens if null values are involved in datetime operations?

986

---

What Are the Main Features of SQL Azure?

117

---

Why can there be only one clustered index and not more than one?

1014

---

How do you send email on SQL Server?

1073

---

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1859

---

How to connect to SQL Azure Database by using sqlcmd?

136

---

Define ACID properties in a Database?

1071

---