You can use CONTEXT_INFO() .. to short circuit the infinte loop.

See the pseudo code

--Trigger on one side

declare @Context varbinary

SELECT @Context = context_info()

IF @Context = 0x35353535

...

Plz send any link.. if there is any detailed information on this

John Mitchell-245523 (9/27/2013)

---

Do you think so? The warning messages occur at...

i dont think only SP definiton will provide much help here . Exec plan will be required.

Yes.

There are a lots of chages in many DMVs structure. See http://blogs.msdn.com/b/sqlosteam/archive/2012/07/11/memory-manager-surface-area-changes-in-sql-server-2012.aspx

Is it ???? then i totally discourage the rule/approach here .

Even you CANT restrict...

mote.ajit2 (9/27/2013)

---

Just want to know how does it works?? I mean is it work like first update will e done then go for check constraint validation. if check constraint violated...

curious_sqldba (9/26/2013)

---

Now in my nc index when i dont include C2 it is still using the right index, but when i dont include c1 it is not using the right...

i also use Red gate sql developer bundle . its had great sub tools sql compare , data compare and intellisense also

jatighe (9/27/2013)

---

It is the randomness of the problem that I am struggling with. The Informatica workload is restarted each time it fails and it always works the second time it...

Yes . it WILL count the dirty reads .

Rem70Rem (9/26/2013)

---

If I restart the SQL server just before, the process take a bit more then 1 hour. After a week, the same process takes 2hours. I can't...

Generally i read article or Ebooks but ther is one book whic make me desparate to purchase it "Sql server 2008 internals" by kalen daleney. i have tried...

This wil help you http://msdn.microsoft.com/library/ms189121.aspx

So you are...