Home > Archive > MS SQL Server DTS > July 2005 > sp_helpuser for groups









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author sp_helpuser for groups
Enric

2005-07-22, 7:23 am

Dear gurus,

I'm using sp_helpuser for obtain info about NT user. That's fine but i find
a problem when I use with a group
The name supplied (CM\52767641) is not a user, role, or aliased login.

Does anyone know which would be the sp focused to groups??

Regards,

Allan Mitchell

2005-07-23, 3:23 am

Are you sure that this is the name of the user?

Remember a user and a login are not the same thing and can be named
differently. Have a look in the users folder of your DB



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Enric" <Enric@discussions.microsoft.com> wrote in message
news:7C5461FC-A585-4533-A960- C3EAD64A5A2E@microso
ft.com...
> Dear gurus,
>
> I'm using sp_helpuser for obtain info about NT user. That's fine but i
> find
> a problem when I use with a group
> The name supplied (CM\52767641) is not a user, role, or aliased login.
>
> Does anyone know which would be the sp focused to groups??
>
> Regards,
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com