Thanks. We have SQL 2012 sp1 CU7, dated November 13, 2013

The link you provided says it was fixed in CU8, dated January 20, 2014. Will check it out.

Currently, these are the settings:

Script owner False

Script permissions False

When I changed them to True,...

I've also been evaluating monitoring software. Spotlight has changed to an instance pricing model, which could get pretty expensive pretty fast. We were quoted about $1,500 per instance. There's also...

Is there any benefit to creating a generic system account and assigning all subscription owners to this?

Is the owner the only one who can attach subscriptions to reports?

We've also got...

I've used variations on this in the past, with the insert into #temp exec xp_cmdshell 'dir'

I tried to wrap this in a stored procedure, to be used by other procedures,...

Hmmm. I thought we had removed all WITH SCHEMABINDING all, but found two that didn't have it. Thanks.

We're running into the same user. I made sure the following:

- running SQL 2008 SQL Agent as a Windows admin account called "SqlService"

- ensured that that account has full access...

The article was thorough and straighforward.

I find the problem with ChangeTracking and ChangeDataCapture is that there is so much hardcoding going on. That means whenever you add or delete a...

I got a bit interested in the Size column, but then later found out it was kind of bogus.

http://connect.microsoft.com/SQLServer/feedback/details/377223/sys-master-files-does-not-show-accurate-size-information

Also want to add the clause:

Where status <> 66056 -- offline

Replication is one of those nasty things that it keeps having a number of hooks. What you may want to do is completely destroy replication on that box and rebuild...

I admit this is a newbie question but what does MOF stand for? Initial searches came up with matches, but no one else seems to want to explain it.

I try...

I forgot one statement:

"My way is the only right way. You're doing it wrong."

Whether that's true or not, there's a better way to phrase that. The most memorable time is...

What you say has sometimes been my experience as well, but whether they're looking to move up or not is less important, unless it's to your detriment. Finding a boss...

A lot of the dumb answers come down to the employee not helping the manager. Someone a long time ago told me that his primary (and only) job function was...