The replmonitor database role in the distribution database.

When there are an excesive amount of lock or contention in the distribution database you get those time-outs. Are people deleting/inserting massive amount of rows in a single transaction ?...

Apparently distribution cleanup is not working for you. Distribution clean up is what does the Job you want. You should check the logs for that job and verify the the...

I think I was in the same case before. I had to use SSIS UI to delete a package because normal DB Engine connection would not do it.

What happens is that if the delete statement is sent in a BATCH objectID is not available for batches just for SP:Statements.

So My advice is:

You use and INSTEAD OF...

Not entirely sure but you should check client side code for any unhandled exception. The "missing cursor declaration" part is a hint that something is not working properly on the...

I have been in sooooooooo mmmmmmaaaaannnnyyyyyy war stories that I could put probably a book together but definitely the usual steps take you to the root of the problem. In...

You know exactly that I am talking about standards but hey if you want to play that game with M$ the real answer is ... you never know not "if"...

shepton (10/5/2007)

---

Unashamedly pinched from I can't remember where...

If Architects Had To Work Like Software Designers...

Dear Mr. Architect:

Please design and build me a house. I am not quite sure of what...

Instead of "Database Name" use "Database ID"

Apparently the OP abandoned this thread.

Jeff Moden (10/3/2007)

Columns will be returned in the order listed... variables will be returned (populated) in the order listed. Items in the SELECT list will be done in the...

Matt Miller (10/4/2007)

---

GilaMonster (10/4/2007)

He could connect to SQL normally (not DAC), but queries, even against the system views, just ran and never finished. Hence he was killing spids blind (without...

you should also run sp_blocker script to keep an eye on the processes and "hopefully" identify a long blocking process.

Good Luck

If 32 bit OS you want the OS with 2GB.