Thank you Frank Kalis.

I will try the ADO stream object.

Thanks again

Thanks for your reply Gil_Adi.

I've tried to reinitialize the subscription, but nothing changed. Only the snapshot is run again, when updating the data from subscriber the publisher no any update

Thanks

...

Thanks for your reply.

The problem had been resolved

after the subscription created, i should call the start job function to run the snapshot agent, then only the artical and all required...

Please help again

I've followed the MS support info but still failed.

When register the sqldmo.dll, i have received nothing ,even no message popup to show whether it is success or failed,...

Thanks a lot Allen_Cui

hi mdamera,

thank for your reply, i forget to mentioned on point i.e i need myprogram.exe to be run asynchronously.Because xp_cmdshell operates synchronously.

i've though on way to do that, but...

Thanks to Andy Warran.

base on that paragraph, if i'm using

MSDE 2000, then only can make the PC2 as a standard subscriber for Transactional publication, which means that cannot set the...

Thanks for your reply.

Forget to mention, PC2 is a desktop engine (MSDE), base on the MS documentation, MSDE is not support transactional as Publisher only, i don't think is this...

Sorry ,post in the wrong place

Thanks for all your advices

I have designed my project in this way, but don't know whether it is the right solution.

I have two type of client program

1) Buffer Client

2) Operation...

then i need to add identity field for sorting already. any others ways

Thanks

Thanks for all of you

In my project, there are actually more that 30 clients will directly connect to SQL Server. Whwn me buy standard edition package which come with 5...

Thanks for your suggestion.

Actually, i have a bit confusing.

Currently, all my client directly connect to sql server to perform DB maintenance operation. I think it is not a good way...

Thanks for your reply AndyWarren.

The first way that you mentioned by using xp_sendmail , is it will cause more overhead of the system ?

i'm trying to use dynamic cursor, since...

Thanks to Antares686 and again Andy Warren

i've thought an approach, i can create a SP with required params on the MAIN sql server which can be called from all my...