Removing Logins from Server and Databases

Is there any way to remove logins from the server and all related databases
in including all roles in the databases?
Thanks,
David
====================================== David McCarter
www.vsdntips.com
VSDN Tips & Tricks .NET Coding Standards available at:
www.cafepress.com/vsdntips.20412485Hi,
Execute
sp_helplogins <loginname>
This will list out all the roles and users associated for the login. Then
you could use the appropriate system procedures to drop the users,login and
roles.
Take a look into books online for below system procs
sp_dropuser
sp_droprole
sp_droplogin
Thanks
Hari
SQL Server MVP
"dotNetDave" <dotNetDave@.discussions.microsoft.com> wrote in message
news:0B172044-F55A-47D2-B812-ED45DED0BB21@.microsoft.com...
> Is there any way to remove logins from the server and all related
> databases
> in including all roles in the databases?
> Thanks,
> David
> ======================================> David McCarter
> www.vsdntips.com
> VSDN Tips & Tricks .NET Coding Standards available at:
> www.cafepress.com/vsdntips.20412485|||Thanks. I was hoping for one command to do it all ;-)
"Hari Prasad" wrote:
> Hi,
> Execute
> sp_helplogins <loginname>
> This will list out all the roles and users associated for the login. Then
> you could use the appropriate system procedures to drop the users,login and
> roles.
> Take a look into books online for below system procs
> sp_dropuser
> sp_droprole
> sp_droplogin
> Thanks
> Hari
> SQL Server MVP
> "dotNetDave" <dotNetDave@.discussions.microsoft.com> wrote in message
> news:0B172044-F55A-47D2-B812-ED45DED0BB21@.microsoft.com...
> > Is there any way to remove logins from the server and all related
> > databases
> > in including all roles in the databases?
> >
> > Thanks,
> > David
> >
> > ======================================> > David McCarter
> > www.vsdntips.com
> > VSDN Tips & Tricks .NET Coding Standards available at:
> > www.cafepress.com/vsdntips.20412485
>
>|||Hi,
You could do every thing using SQL Enterprise manager / SQL Server
Management studio. But internally it does all the below commands.
Thanks
Hari
SQL Server MVP
"dotNetDave" <dotNetDave@.discussions.microsoft.com> wrote in message
news:6308E118-80EA-4D9D-8621-578F9E514209@.microsoft.com...
> Thanks. I was hoping for one command to do it all ;-)
> "Hari Prasad" wrote:
>> Hi,
>> Execute
>> sp_helplogins <loginname>
>> This will list out all the roles and users associated for the login. Then
>> you could use the appropriate system procedures to drop the users,login
>> and
>> roles.
>> Take a look into books online for below system procs
>> sp_dropuser
>> sp_droprole
>> sp_droplogin
>> Thanks
>> Hari
>> SQL Server MVP
>> "dotNetDave" <dotNetDave@.discussions.microsoft.com> wrote in message
>> news:0B172044-F55A-47D2-B812-ED45DED0BB21@.microsoft.com...
>> > Is there any way to remove logins from the server and all related
>> > databases
>> > in including all roles in the databases?
>> >
>> > Thanks,
>> > David
>> >
>> > ======================================>> > David McCarter
>> > www.vsdntips.com
>> > VSDN Tips & Tricks .NET Coding Standards available at:
>> > www.cafepress.com/vsdntips.20412485
>>