Viewing 15 posts - 24,871 through 24,885 (of 39,810 total)
Absolutely, time for lunch. Right after I put my daughter to bed.
March 9, 2009 at 9:09 pm
There's still some v65 and v7 servers out there running fine.
March 9, 2009 at 9:06 pm
Gus,
Don't forget plenty of third party products, like SQL Backup, can give you compression, at a substantial savings over upgrading.
March 9, 2009 at 4:28 pm
Good points on the tail wagging the dog, and I'd forgotten service packs can extend out support. I'm not sure you'll get a GDR for your SQL Server 2000 SP4...
March 9, 2009 at 4:22 pm
I'd call MS support. Not sure anyone else can help you here.
Moved to SQL 2000.
March 9, 2009 at 2:32 pm
It builds a package in Integration Services. You can save it and then open it up in BIDS.
March 9, 2009 at 2:31 pm
What do you mean by getting killed?
Have you benchmarked? Any counters changed? Possible workload changes?
21GB might take some time to run up to 44GB. Can you run some larger queries...
March 9, 2009 at 2:30 pm
datecreated on installation folder? (/binn)
March 9, 2009 at 2:21 pm
I might also be sure that the spacing is there. If you might have more than one space, I'd consider using charindex/patindex to find the parens and go from there.
March 9, 2009 at 9:16 am
I'll add my reasons in here why I approved this question. I think it's good, and I see the arguments why log shipping might be seen a easy.
However, getting rights...
March 9, 2009 at 9:14 am
Excellent job, Brian, and a great solution. Wish we had a good one for 2000, but having this handy would be nice for blocking people making attempts to crack security...
March 9, 2009 at 8:55 am
Ninja's_RGR'us (3/8/2009)
LOL, ROTF.
Et tu, Ninja, ROFL 🙂
March 8, 2009 at 4:59 pm
Take it to PASS and it would be great for them to review stuff that is published elsewhere.
I don't want to get too much editorial stuff here. We like the...
March 7, 2009 at 4:40 pm
We've talked about doing something with the briefcase, more like a "clipboard" of stuff, but making it public might help.
We have 4 or 5 articles on T-logs, but I...
March 7, 2009 at 4:37 pm
Kerry,
A couple things. First I edited the subject so as not to disclose your email. I'd be wary of that.
Second, I'd create a role. Right click Roles, new role, and...
March 7, 2009 at 10:48 am
Viewing 15 posts - 24,871 through 24,885 (of 39,810 total)