Agreed about scanning existing permissions. I had considered adding this to the article but it was already getting lengthy. Plus there are a ton of postings on how to do...

We also used AD groups in this implementation. The system is set up in such a way that any approach is possible. It can grow or shrink as needs arise....

Found the solution on another forum:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/4691a3df-5ad1-480a-8d27-2bda7afd7078/sql-2014-upgrade-advisor?forum=sqlsetupandupgrade

Basically, you have to have the right version of SqlDom.msi installed. I believe the upgrade advisor relies on the 32 bit version.

Please on the following...

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...