What are the different types of upgrades that can be performed in sql server?

0 Answers  

---

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

0 Answers  

---

what is trigger . hw will it use them

2 Answers   TCS,

---

Where are sql server user names and passwords stored in sql server?

0 Answers  

---

What is the maximum length of an alert name?

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 log ldf?

0 Answers  

---

Describe in brief authentication modes in sql server.

0 Answers  

---

What are the main differences between #temp tables and @table variables and which one is preferred?

0 Answers  

---

What is a deadlock and what is a live lock?

0 Answers  

---

can a database be shrunk with users active? : Sql server administration

0 Answers  

---

Where are stored procedures in sql server?

0 Answers  

---