Thanks for your reply! I assumed it was possible, but still can't find much on the topic other than one-off websites and not really any meat-and-bones info of pros/cons...

Hi, Keith

Right you are. I was under a mis-conception that structure changes did not cause an automatic recompile. However, we also frequently add new indexes.... Also from...

We also do that nightly (except for once a week when we run the recompile). We use:

EXECUTE master.sys.sp_MSforeachdb 'USE [?]; EXEC sp_updatestats'

I was under the impression, tho, that msforeachdb...

Hi, all. No ideas on how to view the full error? Bummer. 😉

Grant, I'll see what I could do with the brackets, although I'm pretty green with...

Thank you for your replies. It took some time but we've found a workaround and MS believes it is a bug and they are going to investigate further.

The answer...

Thanks for the replies and sorry for the delay in response. The person I'm troubleshooting this for is out on leave so it became a lower priority. 😉

Just...

This script is great!!! It's something I've wanted but even beginning it was way over my head. I assume you are using conditional formatting on the cell color in...

That'll do it! Glad you got it sorted out. 🙂

Did you check the account that is running the command? In addition to the auto_fix, it could be a permissions/role issue:

IF NOT EXISTS(SELECT * FROM sys.database_principals WHERE name =...

Has the database been restored recently? Doing so could create orphans and it sounds like your permissions have changed. Ensure that the account on db you are truncating...

On a long shot, did you check the job and make sure that the step that backups up the master db doesn't have "On Success Action" set to "Quit the...

FYI~

When I ran this on 2008 R2, I received the error:

Msg 15281, Level 16, State 1, Procedure xp_sendmail, Line 1 SQL Server blocked access to procedure 'sys.xp_sendmail' of component...

Fantastic! Thanks for the link, I'm sure it will be useful to others, too. I was suprised that it's so hard to find. 🙂

I've yet to find a good config mgmt template for the SLA part, but more on that point:

You'll want to define how different priorities are handled. What if you...

I don't really know of any templates because it's typically defined specifically for your company. Are you aware of ITIL best practices?

You need to determine what needs tracked...