Viewing 15 posts - 16 through 30 (of 45 total)
I very much appreciated the connection and feedback about Rob's article. I have felt that way at times, too, but never really had the means to discuss my REALLY strong...
April 20, 2015 at 10:06 am
This was some great code, Jack. Much of it is working well. However, the cdc_DBName_capture job is taking a heck of a long time. It needs about 18 hours of...
February 24, 2015 at 6:47 pm
The best answer I've had for keeping the LDF and MDFs for system databases in the same directory is that they're that way by default on install and there's no...
November 17, 2014 at 4:37 pm
Not so much. It seems that all the Change Data Capture stuff is a "push" to the destination.
I was hoping that it would be more like replication where the Subscriber...
October 17, 2014 at 9:42 am
We've had good success lumping similarly used tables and procedures into schemas and then creating a role for the schema and assigning "User" permissions to the role, specifically SELECT, INSERT,...
October 15, 2014 at 11:11 am
I remember doing this as well. Created a bunch of views in a separate schema that the users had access to. The views had friendly column names and made it...
September 25, 2014 at 9:18 am
In many ways, that would be true. But they didn't wan't to write a new package, or add to an additional one, every time they have new SQL. Doesn't really...
September 24, 2014 at 4:54 pm
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...
July 30, 2014 at 1:10 pm
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....
July 30, 2014 at 8:50 am
Found the solution on another forum:
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...
July 8, 2014 at 10:05 am
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.
February 26, 2014 at 3:14 pm
Currently, these are the settings:
Script owner False
Script permissions False
When I changed them to True,...
February 25, 2014 at 5:40 pm
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...
January 29, 2014 at 10:54 am
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...
April 3, 2013 at 12:42 pm
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,...
November 16, 2012 at 11:47 am
Viewing 15 posts - 16 through 30 (of 45 total)