What are the steps need to be take improve the speed of a SQLDATA Server?

2 Answers   IBM,

---

PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs.

6 Answers   APX,

---

What are basics of policy management?

0 Answers  

---

List the ways in which dynamic sql can be executed?

0 Answers  

---

What is nested transaction?

0 Answers  

---

---

Rate yourself in .NET and SQL ?

1 Answers   Cognizant, HCL, SunGard,

---

Explain user defined functions?

0 Answers  

---

What it means to be triggered?

0 Answers  

---

Find first and last day of current month in sql server

0 Answers  

---

How are SQL Server databases physically stored under Windows 2000?

1 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  

---

How will you monitor replication latency in transactional replication? : sql server replication

0 Answers  

---