David,

This article is extremely helpful. Great job and thank you for submitting!

I am running into a problem connecting to some of my servers, not all. I...

That's what I see as the drawback as well, when you look at the permissions to the stored procedure you don't see the user listed. Guess I'll just have...

In my original post I paraphrased the table/index names, I did not do that here, so it names may look slightly different. See attachment.

Yes it is a deadlock situation, one of the processes gets a 1205 error and an email is generated.

I set the switch last night. The error log showed a...

Exactly what I assumed. I needed some expert opinions to validate.

Thank you both for the timely answers!

Paul Randal (11/17/2009)

---

If this is the only error, then repair won't cause any data loss, as the image that it references isn't linked into the table.

Is this a database that...

I researched the syntax error and found the following thread:

http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/dc52e0d9-af14-46b9-9904-29b9afa798cd

Basically I updated the job by check marking the local connection under datasources tab and that did the trick....

Update: Since I recreated the above SPs I tried to run a job through the Job Activity Monitor. Now it fails right...

Alex,

I appreciate your help with my issue. I reviewed the KB article and I don't believe it applies to...

I just reviewed sysdbupg.sql that I attempted to run before and found drops/creates for these objects:

sp_validate_user

sp_help_jobhistory_full

sp_help_jobhistory_summary

sp_help_jobhistory_sem

I ran the creates for these.

I compared sys.objects to another instance and found a difference...

I currently have SP2 installed so I am wondering why those views are not there in the...

Thank you!

I guess I will hold off unless I find a bug. Thank you for your responses.

I'm having a similar problem, here's my situation:

Oldest unsent transaction is 3:50:00 and climbing but unsent log is 0KB. I find this odd, if the there is a transaction...

Yes, this is a warning if the age of the oldest unsent transaction exceeds 5 minutes.

My question is, if it does exceed, is the problem with the network between the...