Viewing 15 posts - 57,646 through 57,660 (of 59,048 total)
Yes... instead of using the "-o somefilename" parameter, use the DOS "redirect as append" characters ">> somefilename".
September 13, 2006 at 6:33 pm
Sorry Vandy... I just can't read minds today... what's not right about the total sum?
September 13, 2006 at 6:37 am
Vandy... how about telling us which columns the +ive and =ive numbers are stored in? If they are both in the InvoicedValue column, then Marino's should have done the trick...
September 13, 2006 at 5:30 am
Better make sure you do a backup before you truncate the log or you won't be able to recover to a point in time which is the purpose of Full...
September 13, 2006 at 5:00 am
Sure... what's the Primary Key of the person table?
September 12, 2006 at 5:24 pm
Maybe this weekend... right now, I'm still sucking my thumb wonder what the heck I was thinking ![]()
September 12, 2006 at 5:21 pm
I'll say... as for me, I can't find the examples I had made for something else (might not even be the same problem
...
September 12, 2006 at 7:27 am
Outstanding... thank you for the feedback.
September 12, 2006 at 6:52 am
Ok... first things first...
Rob... I'm confused... I thought you were saying that some sproc OUTSIDE of the trigger was being rolled back and that you need what was happening inside...
September 11, 2006 at 8:56 pm
The only way to keep from rolling back the record inserted by the trigger, is to do it with another connection.
SP_OA could be used to create such a connection...
September 11, 2006 at 6:54 pm
...and, still, if you have FULL RECOVERY set, none of that will help the LOG file because all of the updates will be recorded whether they be single updates, batches,...
September 11, 2006 at 5:54 pm
JUST in case you need it as a single query (In the absence of CTE's, I do like the temp table solution better which is why I didn't answer previously...
September 11, 2006 at 5:50 pm
Yes, it does make sense... What I'd recommend is writing a script that would populate a working table (permanent table that will last until this problem is resolved and then...
September 11, 2006 at 8:13 am
The update isn't really ignored if there's no match... it just doesn't update anything although it is executed.
September 11, 2006 at 6:51 am
Try adding the -c parameter. If that doesn't do it for you, add the -C parameter with the proper code page (see Books Online for the proper code page.) Do...
September 11, 2006 at 6:50 am
Viewing 15 posts - 57,646 through 57,660 (of 59,048 total)