Viewing 15 posts - 91 through 105 (of 120 total)
wow. this is getting ugly. I think I'm just going to stick with the tried and true Data-Massage therapy I had been applying in some similar import situations,...
March 4, 2003 at 2:23 pm
antares, I suspect that you are referring to disconnecting and reconnecting after setting the ANSI_PADDING. right?
I must be screaming now. IT DOESN'T WORK! I have SET (stupid)ANSI_PADDING...
March 4, 2003 at 9:45 am
I must be screaming now. IT DOESN'T WORK! I have SET (stupid)ANSI_PADDING ON and it does not affect the behavior of my Unique Index. this example is...
March 4, 2003 at 9:42 am
where is Antares when you need him...?
March 3, 2003 at 6:16 pm
so far, I'm not having any luck with ANSI_PADDING. I have tried setting it to on (after figuring out that you have to include an 'alter database' if you...
March 3, 2003 at 6:13 pm
intersting idea 5409045121009 (nice name ), but even this seems to have problems to me. You inserted the lengths because you knew them, however if you...
March 3, 2003 at 6:02 pm
I am less confident, and beginning to question my sanity...
Anybody know if this can be changed??? (DO NOT ignore trailing blanks on vachar fields when maintaining Unique Indexes)
Edited by -...
March 3, 2003 at 4:28 pm
alrighty. seems I may have been a bit hasty in blaming DTS. It would appear that it does not have to do with the copy as much as...
March 3, 2003 at 4:10 pm
OH MY! I'm probably a bit late here, but I just came across this on my own today. This was for a package, but I think it applies...
March 3, 2003 at 2:38 pm
you could always use an exec('select <whatever> from ' + @tableName), but I'd not be surprised to hear there are performance issues with this strategy, right guys?
February 20, 2003 at 10:43 am
Thanks Bill, I think I see what the N is for now. maybe. But now for the hard part, . How can you search for...
February 20, 2003 at 10:32 am
thanks tgrignon,
I believe that we have worked around this error (and others) by disabling certain checks in the install and or lowering the severity of such errors in...
February 10, 2003 at 12:51 pm
don't ask what a "defalut" FK is.
February 6, 2003 at 9:54 am
*** correction ***
Table C references table B with a defalut [ON DELETE NO ACTION(restrict)] foreign key.
February 6, 2003 at 9:52 am
not to be ornery or anything , but I submit the following as evidence that SP3 for MSDE was not released with the main SQL2KSP3 from
SQL...
January 29, 2003 at 8:45 am
Viewing 15 posts - 91 through 105 (of 120 total)