usman.tanveer (4/24/2009)

---

The only concern i have is, its a very critical production db and i am afraid enabling Snapshot isolation will give me performance hit by adding more burdon on...

Is it all sorted out now?

No odd characters, I checked, deleted and retyped pieces by hand. There's just a new line between the two (CR LF). I was wondering if I was missing a batch...

Integrity checks of the system databases (master, model, msdb) are highly recommended. Corruption in those can be very hard to fix if you don't have a clean backup, and without...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic704057-359-1.aspx

If all queries were coming from the same connection, there would be no blocking in the first place.

I don't understand your concern with snapshot. It's an optimistic concurrently level that...

Please post some existing sample data from the table. The very first link that I gave you shows how to do that easily.

Why can't you change the table structure?

Check the SQL error log. Any errors or prints from a logon trigger go in there.

I would suggest wrapping the code in a TRY.. CATCH block and have the catch...

If your indexes are all optimal you should be getting row-level locking anyway.

Have you considered snapshot isolation? It'll hit TempDB hard if you have that much activity, but you'll have...

Note to self. Get to the point..., 😉

...

usman.tanveer (4/24/2009)

---

Thanks for the reply Grant, i agree but i have no other choice to try this if possible, as the queries are coming from a dll (which i cannot...

Jeffrey Williams (4/24/2009)

---

sharanurampur (4/24/2009)

---

Dear Friends,

I too don't know the exact problem, what I am predicting is we are having 2...

Grant Fritchey (4/24/2009)

---

However, it's possible to have written a data access layer that won't work with 2005 (I know because two different development teams in my company did it). You...

One thing I would like to get clear.

Are you backing up the transaction log to the same file every time?

Do you have the overwrite option specified?

And auditing. In fact, I'd almost go as far as saying...