Viewing 15 posts - 31 through 45 (of 49 total)
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
Hmmm. I thought we had removed all WITH SCHEMABINDING all, but found two that didn't have it. Thanks.
April 27, 2012 at 1:02 pm
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...
January 11, 2012 at 3:10 pm
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...
November 28, 2011 at 9:57 am
I got a bit interested in the Size column, but then later found out it was kind of bogus.
November 11, 2011 at 11:33 am
Also want to add the clause:
Where status <> 66056 -- offline
November 11, 2011 at 9:55 am
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...
October 20, 2011 at 4:10 pm
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...
May 16, 2011 at 3:01 pm
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...
January 26, 2011 at 1:58 pm
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...
January 26, 2011 at 1:55 pm
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...
January 26, 2011 at 12:37 pm
That was a good one, Leo, but it only showed the successful job. The "orphans" are not appearing.
January 13, 2011 at 9:21 am
Viewing 15 posts - 31 through 45 (of 49 total)