Of course then you need to add the SPs also

What that means is that that the necessary replication components are created in order to get the connection up and function between the publisher/distrib/subscriber ... if you want to modify/add...

I am going to bet that if you script out the subscriber you are going to see that the sync_method is set to "for replication only".

What happens after replication is up and running and later you need to add a new article?

Having the @sync_method set to 'for replication only" would then mean you would have...

Thanks for the info!

SO ... if I register now to get the discount and then say a couple of months down the line a deal is worked with PASS or...

Thanks Noel.

That is exactly the configuration we have (albiet we have not created the new x64 server yet and a different name will not be an issue since we are...

BOL to the rescue again (once you hit on the right combination of words - lol).

We are going to be able to execute this process leveraging Replication and Mirroring.

The mirrored...

Thanks for the info.

We are absolutely testing this before the real project is cut loose.

Just trying to get any info from others who may have tried this process in the...

I do not beleive you have to use the proxy account if the login that is executing the xp_cmdshell is part of the sysadmin group ... which it is.

I will...

I have to also add my 2 cents here - lol.

Due to the new regulations coming from SOX (Sarbanes-Oxley) and being pushed down corporate America's throat, I am being regulated...