Viewing 15 posts - 31 through 45 (of 45 total)
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
That would have been nice. I suspect that somewhere there is an orphaned job ID in a sys table that has information that is on it's own. I just don't...
January 12, 2011 at 5:35 pm
While reading this post, I believe I have a similar question. There are tables that exist in dbA and dbB. I wish to create an fast view in dbC, as...
December 6, 2010 at 3:02 pm
Any ideas on this one? Or a direction to take in solving it? Could it be something unrelated to the sys tables?
Any suggestions are welcome.
Thanks
Andre
December 3, 2010 at 12:16 pm
Viewing 15 posts - 31 through 45 (of 45 total)