Viewing 6 posts - 1 through 6 (of 6 total)
The biggest concerns with this approach is how to deal with the big XML documents. Obviousely, it is limited to 8000 chars.
David Zeng
September 20, 2004 at 10:27 am
This is actually a big topic in database world--3 values logic!
Basically, when you SET ANSI_NULLS ON, the database is following 3 values logic, where whatever opperations with NULL will be...
July 28, 2004 at 7:15 am
I am not sure what the behavior would be in DB2, Oracle or other database. But I think this is not a good implementation (probably a flaw?) in SQL Server, because it...
July 27, 2004 at 9:51 am
Could you post your DTS to let us take a look? I guess you should turn on execution option "Close connection on completion" in your DTS.
Hope it help,
David Zeng
July 23, 2004 at 9:40 am
It sounds like you have almost gotten it done. Next time, you could try taking offline your database to make copy of the database files. Then copy the files to...
July 22, 2004 at 6:49 am
The changes would not be captured when the orderid is changed. I would write 2 statement, one to capture changes from inserted, the other to capture changes from deleted. It would be complete...
June 15, 2004 at 7:09 pm
Viewing 6 posts - 1 through 6 (of 6 total)