removing user

Hello,
I have a problem with removing an user on a SQLSERVER V7 base.
I can suppress the user, but it still exist for the role PUBLIC.
Can you help me ?Do you mean that you remove the user from the database, but they can still get in through Public, or are you getting an error when you try to delete the user?

blindman|||Hi...
What u mean by suppress the user...? What errror message u r getting?
U can remove user from User Roles still it will exists in Public. Do the user owns some objects ? guests are allowed in the DB ?

Cheers :)

Shaji

Originally posted by jleb
Hello,
I have a problem with removing an user on a SQLSERVER V7 base.

I can suppress the user, but it still exist for the role PUBLIC.

Can you help me ?|||I remove the user from the database, but it still exists whem I look the Public role.

Thank you fopr your help, I have found a solution with the command sp_revokedbaccess.

Originally posted by blindman
Do you mean that you remove the user from the database, but they can still get in through Public, or are you getting an error when you try to delete the user?

blindman

removing a snapshot agent.

I have a snapshot agent that I cannot get rid of. The publication did
not exist, so I went into distribution.MSsnapshot_agents table and
delete it. When I refresh the snapshot agents folder, it is gone. At
some point, the damn thing gets recreated.
What is recreating this agent? How can I stop it for being recreated?
Larry...
Are you using dynamic snapshots? This is a merge replicaiton only feature.
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
"LPR-3rd" <lreames@.gmail.com> wrote in message
news:1115044813.754502.295220@.f14g2000cwb.googlegr oups.com...
> I have a snapshot agent that I cannot get rid of. The publication did
> not exist, so I went into distribution.MSsnapshot_agents table and
> delete it. When I refresh the snapshot agents folder, it is gone. At
> some point, the damn thing gets recreated.
> What is recreating this agent? How can I stop it for being recreated?
> Larry...
>
|||I am not using dynamic snapshots. It is a simple transactional pub.
What do you mean..'This is a merge replicaiton only feature.'?

removing a snapshot agent.

I have a snapshot agent that I cannot get rid of. The publication did
not exist, so I went into distribution.MSsnapshot_agents table and
delete it. When I refresh the snapshot agents folder, it is gone. At
some point, the damn thing gets recreated.
I am not using dynamic snapshots. It is a simple transactional pub.
What is recreating this agent? How can I stop it for being recreated?
Larry...
A stray snapshot agent job that runs periodically may be re-creating the
snapshot agent entry in MSsnapshot_agent. Can you check whether there is a
snapshot agent job step in sysjobsteps that doesn't correspond to any known
publications?
"LPR-3rd" wrote:

> I have a snapshot agent that I cannot get rid of. The publication did
> not exist, so I went into distribution.MSsnapshot_agents table and
> delete it. When I refresh the snapshot agents folder, it is gone. At
> some point, the damn thing gets recreated.
> I am not using dynamic snapshots. It is a simple transactional pub.
> What is recreating this agent? How can I stop it for being recreated?
>
> Larry...
>