Viewing 15 posts - 31 through 45 (of 322 total)
Well I have managed to get 2000 to pull from 2008 over 2 local sql servers so the documentation from MS isn't totally correct.
So now I just have to find...
August 10, 2011 at 5:41 am
Ah sorry I didn't notice that it involved Partioning despite the thread title!
You either need to include that Partitioning column in the other table and denormalize, or....ermmm......not sure. I guess...
August 10, 2011 at 4:45 am
For a database you could throw a simple query at it every 5-10 minutes and log "success" in a table.
If you want to do it at Server level, report back...
August 10, 2011 at 3:56 am
You have 2 columns in the primary key, 1 column in the foreign key
August 10, 2011 at 3:52 am
Yeah I can push the data from 2000 to 2008, but as I say I think my big issue is that it may be that it can't pull from 2008...
August 10, 2011 at 2:15 am
I'm stuffed I think (although my slight hole in network knowledge may be hindering my ideas)
I've now read that with replication to/from previous versions the rule to follow is that...
August 9, 2011 at 9:23 am
I guess one way around it would be to install 2008 SSMS client only on the 2000 box (but they could open up a can of .net worms I'd imagine...
August 8, 2011 at 8:52 am
So definitely no "Keep logs for x amount of days" in there?
August 8, 2011 at 8:37 am
Caught me out therefore an annoying question 😛
(obviously wouldn't have caught out anyone that ran it as usual...)
August 5, 2011 at 3:26 am
In the absence of an SP listed in the question for the SQL install, I'd assume he is referring to vanilla flavour.
Totally agreeing to disagree 😛
July 29, 2011 at 4:02 am
No excuses people I mean if follow the question in your head, it fails before you get to installing any SPx so follow the question and its all in front...
July 29, 2011 at 3:31 am
Murray, surely that wouldn't make a difference to the question as it states you are doing the default install with default options - no SP.
I got it right but took...
July 29, 2011 at 2:27 am
Check your Distribution db size. It could be that your retention for the Distribution agent is ridiculously high therefore cleanup tasks and log backups take longer therefore Log Reader gets...
July 28, 2011 at 10:23 am
Looks like it is a registry issue with the Analysis services snap in. Although its in the registry under MMC, its for the old Version pre sp4 which suggests it...
July 28, 2011 at 10:17 am
Did anyone else set up some SQL Jobs that may be calling this task at different times?
We had a job on our server that seemed to be logging every 2...
July 28, 2011 at 3:46 am
Viewing 15 posts - 31 through 45 (of 322 total)