The Replication of SQL Server 2005
Hi
everybody.
I have a problem that about the Replication of the SQL SERVER 2005. If there are a hundred data in the delivery of replication ,but after they transmited fifty data ,the internet is disconnection.
The question is how about the rest of the undelivered data and the delivered data. Do the delivery data will be rollback? If it dosen't be rollback how dose the administrator of the database know the error of the replication of the data,the most important is how to know the data has not complete delivery.
If it will be rollback and how do we check the error of the internet at immediately..
Thank you !
[666 byte] By [
no_and_fo] at [2007-11-11 9:59:11]
# 1 Re: The Replication of SQL Server 2005
It depends on how u send the data;
If it's in a queue once the interption happen, it will give u an error continuing the send process .. if it isn't so your data will be lost , u may use a flag to check the return value of the send process and know whether it's sent completly or not .
hope this helps .
Amahdy at 2007-11-11 17:23:24 >
# 2 Re: The Replication of SQL Server 2005
Sorry to intrude in your post, Please help me with the Soting text file by SJIS Characterset problem.
# 3 Re: The Replication of SQL Server 2005
What's your problem exactly ? if u want to sort it u can put strings in an auto sorted listbox and get them back from the listbox to write them again into your file , sorted .. is this what u need ?
Amahdy at 2007-11-11 17:25:30 >
