Viewing 15 posts - 541 through 555 (of 588 total)
My experience is not to use mapped drives. In your backup statement use the fully qualified name. i.e. \\servername\sharelocation .
I got the a directory called backups on the M...
March 5, 2007 at 12:21 pm
Is the server you are having problems with on Windows 2003 and the others on Windows 2000? The way map drives work changed drasticaly between the two.
March 5, 2007 at 9:11 am
How about using except?
create
table #employee (EmployeID int, Emprate int)
create
March 1, 2007 at 12:02 pm
I had two versions of the code, noe that ran during the day with the delay, and another one that did larger batches without the delay for running at night...
March 1, 2007 at 9:39 am
I have succesfully archived 120 GB out of a database in the past using a very similar method to the above while the server was in production, none noticed any...
March 1, 2007 at 8:53 am
Is that software or hard raid?
Only time I have seen that radical difference in performance between two very similar systems someone had turned on software compression on the slow system...
March 1, 2007 at 8:44 am
You're welcome.
Those that have seen my code here and in other posts know I believe in making it as simple and general as possible, figure that way people that have similar...
March 1, 2007 at 8:11 am
Something along the line of this:
create
table #Sales (
SalesmanID int,
Totals money)
insert
February 28, 2007 at 12:53 pm
Haven't tried this in SSIS, but it looks like you have 3 double quotes in a row. Try to enclose it search value with single quotes?
REPLACE
February 28, 2007 at 10:10 am
Nah these are all local jobs, run off local packages on the server to local hard drives.
I do belive it has something to do with the domain change for...
February 28, 2007 at 9:08 am
I thought this change to US dates was to make us use the same dateas as the EU. At least that was what I got explained to me. Is UK...
February 28, 2007 at 6:39 am
It showed nothing either. I mean, absolutely nothing. Which indicates to me that the call to run the maintenance plan actualy never executed it, I would think....
February 28, 2007 at 5:36 am
I think the real answer would be to keep that information stripped out in another column, but the below code will strip it out, here as an example using a...
February 26, 2007 at 1:30 pm
It doesn't even create a log file, for either of the steps.
The cleanup job is basically 5 individual cleanup items for the 5 databases I want to clean up, the...
February 26, 2007 at 11:28 am
Viewing 15 posts - 541 through 555 (of 588 total)