Replication of users

Hi,
I have setup a process so I can replicate users and logins between my
publishers and subscribers. This I have done using the replication of stored
procedure execution.
Now the problem I have is to replicate the sp_revokedbaccess sp from
publisher to subscriber.
IT throws me error when I try to replicate the execution of sp saying that
this sp can not be part of a transaction.
Is there any other way to replicate this functionality.
Please advice..
Thank you
Sam
use sp_addscriptexec to replicate the commands to all subscribers deployed
via a unc.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sam" <sam@.discussions.microsoft.com> wrote in message
news:576BFBFB-8C8C-4DCE-8510-BFC472F2C8F9@.microsoft.com...
> Hi,
> I have setup a process so I can replicate users and logins between my
> publishers and subscribers. This I have done using the replication of
stored
> procedure execution.
> Now the problem I have is to replicate the sp_revokedbaccess sp from
> publisher to subscriber.
> IT throws me error when I try to replicate the execution of sp saying that
> this sp can not be part of a transaction.
> Is there any other way to replicate this functionality.
> Please advice..
> Thank you
> Sam
|||Hi Hilary,
Thank you for your response.
I 'm still little confused about how to create a script on fly when a db
user is removed via application and so I want to replicate the same function
on subscriber.
I have to create a script on fly from the sql query execution at the
publisher when a user fires a sp_revokedbaccess command. And we have
xp_cmdshell is blocked on server for security reasons.
What do you think about this situation and how should I implement the
replication functionality?
Sam
"Hilary Cotter" wrote:

> use sp_addscriptexec to replicate the commands to all subscribers deployed
> via a unc.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "sam" <sam@.discussions.microsoft.com> wrote in message
> news:576BFBFB-8C8C-4DCE-8510-BFC472F2C8F9@.microsoft.com...
> stored
>
>
|||I'm sorry I either misunderstood your question or misread your post.
There is no way to dynamically sense the changing users or logins and
replicate this, other than by doing log shipping.
You have to know in advance what user has been added, dropped, modified, and
then encapsulate the commands to carry out this modification and use
sp_addscriptexec to replicate this command to all subscribers.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sam" <sam@.discussions.microsoft.com> wrote in message
news:D1F7D6BA-6C2D-4ECE-8B05-BA1053EAB6E4@.microsoft.com...
> Hi Hilary,
> Thank you for your response.
> I 'm still little confused about how to create a script on fly when a db
> user is removed via application and so I want to replicate the same
function[vbcol=seagreen]
> on subscriber.
> I have to create a script on fly from the sql query execution at the
> publisher when a user fires a sp_revokedbaccess command. And we have
> xp_cmdshell is blocked on server for security reasons.
> What do you think about this situation and how should I implement the
> replication functionality?
> Sam
> "Hilary Cotter" wrote:
deployed[vbcol=seagreen]
that[vbcol=seagreen]