Ill look at the locks but no. That statement is only effecting one row which is a parent record.

parameterized publications can accomplish this.

Sorry for the Newbie question. I found the answer using the online books. I just had to hard code the machine name using the @hostname parameter when runnigng the sp_addmergepullsubscription_agent.

You may want to try Web Synchronization feature but you will still have to use a Domain name with a security certificate instead of an IP address. I just got...

I just started working on a merge replication project for the first time and I remember somewhere in the documentation I was reading that you have to use the Machine...

Ill give those a try, thanks

That worked, thanks for the help.

im getting an error on the With Dups portion of the code.

With Dups as

(

????select *, row_number() over

(partition by Product_Code order by Product_Code) as RowNum

????from #prod

)

Msg 102, Level...

Well I figured out how to correct the problem I was running into. I used the scripting wizard to generate the code to create the database objects /w having collate...

Thanks, I was affraid of that.

Yeah I looked at those per server licensing and it would be nice to have if we had the money to spare, we have dual Xeon processors.

Another question on SQL Server...

The application that access the SQL Server is using SQL authentication.

Found something strange and Im not sure if this should be happening. I enabled edit on the backup task object in my plan and selected the View T-SQL button to...

Seems Im having the same problems too. I setup a Plan to perform a Clean Up History, Full Backup w/Overwrite, Check DB, Shrink Files, and Update Statistics once a week...

Markus mentioned above that using a SnapShot replication doesnt need PK. I have tried this and it does work but its going to send the whole DB every time.