Hello I have two SQL2000 serveers running merge replication. SQL03 is the Publisher and SQL04 is the subscriber. Now when I check the replication...
Hello, I have two SQL server running merge replication. On de subscriber the log files of these databases are huge. here is some data Distributor...
I wanted to avoid that some date/time combinations would fall into a frame of the info_planned_maintenance table. This one holds the date and time of...
I Have two tables with date/time fields. I need to compare the date from one with the date in the other. this is a piece of the code......
Thanks for your tips. I have the solution for my problem.<br />Hope I can help you sometime....[<img src='/community/emoticons/emotion-2.gif'...
Hello, Need some help again...If figured this proc out. the first part is working, the second part..how can I get the update function correct, for...
Oke, I already found the DISTINCT solution, and the other mdofications will be implemented monday.. Thanks a lot for you're help. I learned a lot....
When testing the code, I found one difference. In the resulting table INFO_WORK_PLAN I get duplicate records, that where not there using the old...
Here are the scripts to create the tables used... the rowguid is there, because the tables are part of a merge replication... CREATE TABLE...
I have written this code, and it works, but it slow, and locking up a table so everything go's slow.. Here is the code /****** Object: Stored...
Separate names with a comma.