hello,
is it somehow possible to pass a variable like a database name into a post snapshot script.
i would need to pass a database name into the post snapshot script when creating the replication with sqlcmd.
where the create publication looks like this:
exec sp_addpublication @publication = ... ,@post_snapshot_script = N'$(SnapshotScriptPath)\PostSnapshot.sql',...
and i would need to somehow pass the dbname as a variable in the postsnapshot script.
in the postsnapshot.sql i would then need to set:
use [$(dbname)]
thanks,
Chris