By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,837 Members | 1,720 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,837 IT Pros & Developers. It's quick & easy.

SQL 2005: Transactional Replication > Executing sp on subscribershould execute on publisher

P: n/a
Hi,

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
Jan 15 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi,

I did another cross group posting "SQL 2005: Transact. Repl. >
Executing sp on subscriber doesn't execute on publisher"
on
microsoft.public.sqlserver.replication,microsoft.p ublic.sqlserver.server,
comp.databases.ms-sqlserver
please answer this instead.

Thanks,
Patrick
Jan 16 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.