Thanks, everyone.

Rain

We do see this topic regularly here. The authors of the white paper did some fairly extensive testing. It is theoretical in that it wasn't on a live system being...

There are many issues you could be having. The thing you should do is post more details about what you did in setting up replication as there is no one...

You've got to be assigning privileges to the wrong account or they are logging in with the wrong account, or you have some strange DENYs issued on some tables.

I would...

So the short answer is hire someone to help. A short term consultant to help you debug and determine the issue. I can recommend a few that do remote work...

Craig Farrell (4/25/2011)

---

Steve Jones - SSC Editor (4/25/2011)

---

The UK had holidays Fri-Mon, so I struggled to get someone to come in and check on things this weekend. I managed to...

I believe that with 64 bit you still want to grant this right to the service account. You don't need AWE.

http://blogs.msdn.com/b/slavao/archive/2005/11/15/493019.aspx

The UK had holidays Fri-Mon, so I struggled to get someone to come in and check on things this weekend. I managed to get someone to kick the mail servers...

I think it's a simplistic way of looking at a problem. Parallel problems often use simple data stores, nothing complex, and my guess is this is a start. Over time...

SET ROWCOUNT is supposed to be deprecated in the future. I'd try to work around it wherever you can

http://msdn.microsoft.com/en-us/library/ms188774.aspx

mikes 7125 (4/25/2011)

---

My cousin is now in the hospital, the outlook is not good. We grew up together and are more like brothers than cousins. Life is short. Make the...

Tom@Intel (4/25/2011)

---

Thanks for this message Steve - I am sorry for your loss.

I learned this same lesson last year when I lost my wife after a long battle...

Yes, check SQL Server Configuration Manager, click stop on the SQL Server database engine.

Do not change the max worker threads. That's an advanced setting, and only helps in very few and rare circumstances. The recommendation is to leave this at the default unless...