Thanks for the info. I'll replace the maintenance jobs with better crafted ones.

Is this SQL 2005? You have to allow XP_Cmdshell with the Surface Area Configuration tool.

http://msdn.microsoft.com/en-us/library/ms173748%28SQL.90%29.aspx

All the info you need is a google search away.

http://www.sqlservercentral.com/articles/Administration/2987/

http://msdn.microsoft.com/en-us/library/ms144256(SQL.90).aspx

Of course ideally you'd want a dev environment to upgrade and test it.

As for latest patches, some...

I fit the description Brad wrote. That's definitely encouraging for me that I'm on the right track, and that I'll be a perfect fit as a DBA. Just need some...

Just backup all your databases and then apply the SP.

This should be done in a maint. window obviously because your either have to stop some services during the upgrade or...

There is no one simple answer to your question but you are in the right place. Search these forums and the articles on this site for a ton of good...

taken from: http://www.sqlmag.com/Articles/ArticleID/98709/pg/2/2.html

To determine whether or not C2 audit mode is turned on, you can use the following T-SQL statement, which returns the current value of the C2...

its a permissions issue.

The sql agent service account is a member of the local administrators group on each server?

THis happens to me all the time. We have our SQL accounts set to log on as a service in AD, but after a reboot I often have to go...

have you tried changing localhost to the name of the server?

Clcik Start>Run> type dxdiag and hit enter. Save the log info and post it here.

Look at the application and system event logs. Post here any errors.

If you don't use database mail or any messaging (which is what service broker is for) then you don't need to turn it on. What part of the error you...

Alright ,Thanks much everyone. I'm going to hope for the best. What's worst case? If it can't read the systemresource db I'll get some random errors when we install sharepoint?

EDIT-...

Lesson Learned. Here's the latest startup log. Since it doesn't mention any errors or reference the resourcesystem db, can I be fairly sure I'm ok?

2008-08-18 20:34:02.72 Server ...