SQL 2005: Transactional Replication > Executing sp on subscriber
am 15.01.2008 03:26:50 von PatrickWHi,
I am trying to set up a Updatable Subscriptions for Transactional
Replication with SQL 2005 (queued updating).
I have a stored procedure "SYS_spShellTest" which is replicated to the
subscriber via
the replication option "Execution of the stored procedure":
------------------------------------------------------------ -
ALTER procedure [dbo].[SYS_spShellTest] @cmd varchar(1000)
WITH EXECUTE AS owner
as
BEGIN
EXEC @result = master..xp_cmdshell @cmd, NO_OUTPUT
Return (@result)
END
------------------------------------------------------------ -
1) If I call "exec SYS_spShellTest" on the publisher the call is also
executed on the subscriber.
2) If I call "exec SYS_spShellTest" on the subscriber the call is NOT
executed on the publisher.
How can I make 2) work so that it is also executed on the publisher
please?
Thanks a lot,
Patrick