Answer / praveen

Transaction must be Atomic (it is one unit of work and does
not dependent on previous and following transactions)

Consistent (data is either committed or roll back, no
“in-between” case where something has been updated and
something hasn’t)

Isolated (no transaction sees the intermediate results of
the current transaction)

Durable (the values persist if the data had been committed
even if the system crashes right after).

A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?

2 Answers   Sapient,

---

Do you know what is xpath?

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 purpose does OPENXML clause have in sql server stored procedure?

1 Answers  

---

how can i lock the column in the table

2 Answers   Accenture,

---

How does index makes search faster?

0 Answers   QuestPond,

---

How to use union to merge outputs from two queries together in ms sql server?

0 Answers  

---

What are the steps you will take to improve performance of a poor performing query?

1 Answers  

---

What is database replication? What are the different types of replication you can set up in sql server?

0 Answers  

---

What are commit and rollback in sql?

0 Answers  

---

What will be query used to get the list of triggers in a database?

0 Answers  

---

What is store procedure?

0 Answers  

---