Darn good article Lynn... And the discussion was pretty good. Lots of new ideas to optimize and already optimized solution came out... Great Job. Two thumbs up to you.. 🙂

Selects use shared lock. Do you have any other Inserts or updates going to that table? Are you opening a transaction and not closing it (Commit or rollback)?

When you see the SPID that is blocking, you look and try to find out what the SPID is doing. Your permanent fix is to find out what is the...

Find out what the process are that are blocking. You should be able to see the SPID with the sp_who2 command and then find out what the SPID is doing....

Maybe you could create ask the Net Admins to create a group with all the existing users in it, give the permission to the group. When your head user wants...

We had that issue on lots of stored procs on our Report servers. Basically what is happening (From what I have seen) is that these Stored procs will have IF...

Grant Fritchey (9/22/2009)

---

Hello Threadites. Can someone check this. I can only see a single SPID in the deadlock information posted here, but someone else is seeing lots more. Is something...

Check permission... Thats all I can think off

As per technet

"Migration scenarios in this guide

There are a variety of ways that you can use to perform the overall process of migration, and this guide describes two:

...

I am not sure I would like to have the production Servers Upgraded. I would rather have fresh install of the OS and install SQL Server 2005 (Why 2005? cant...

Did you check the SQL Server error log and the SQL Dump file?

If you add the table as a different Publication, you should be able to snapshot it if I am not mistaken

If I am not mistaken, replication does not care what your recovery model is. It will not allow a transaction to be cleared from T-Log until it has been replicated.

Damn... Thats pretty good. 🙂 So the standard will be pretty high... Then my article is probably going to be rejected... :hehe:

Do they pay...