Answer / babu

The question is not clear.

How many types of system privileges are there, Can we add or delete privileges?

2 Answers  

---

What xml support does the sql server extend?

0 Answers  

---

Are connections to sql server encrypted?

0 Answers  

---

How can you stop stored procedures from recompiling?

0 Answers  

---

What are the advantages of using views. Why do we need views when we have SPs?

4 Answers   247Customer,

---

What is change data capture (cdc) in sql server 2008?

0 Answers  

---

When do u use clustered index and non-clustered index?

3 Answers   IBM,

---

How to loop through result set objects using mssql_fetch_array()?

0 Answers  

---

CREATE TABLE [dbo].[HPMS_CompetencyTypes](CompetencyType varchar(50) ) go create trigger hpms_create_Insert on HPMS_CompetencyTypes for insert as if Exists ( select * from [HPMS_CompetencyTypes] where CompetencyType=(select * from [HPMS_CompetencyTypes])) begin Rollback tran Raiserror ('duplicate value',12,6) go insert HPMS_CompetencyTypes (CompetencyType) values ('new') I'm new to trigger can any one tell me where is the issue. Please.

2 Answers  

---

What is tempdb database? : SQL Server Architecture

0 Answers  

---

Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?

2 Answers   Cognizant,

---

How does a profiler work?

0 Answers  

---