Viewing 15 posts - 1 through 15 (of 30 total)
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...
October 22, 2014 at 7:53 am
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...
February 4, 2014 at 7:56 am
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...
February 4, 2014 at 7:48 am
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...
February 4, 2014 at 7:33 am
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.
November 4, 2013 at 1:03 pm
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. 😉
October 11, 2013 at 8:48 am
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...
May 9, 2013 at 10:11 am
That'll do it! Glad you got it sorted out. 🙂
April 18, 2013 at 11:39 am
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 =...
April 18, 2013 at 9:17 am
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...
April 18, 2013 at 7:40 am
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...
September 28, 2012 at 1:48 pm
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...
September 24, 2012 at 2:07 pm
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. 🙂
September 4, 2012 at 8:09 am
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...
September 4, 2012 at 7:52 am
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...
September 4, 2012 at 7:24 am