sp_helprotect on windows logins

when i run the following,
EXEC sp_helprotect NULL, 'DOMAIN\USERNAME'
i get
Msg 15330, Level 11, State 1, Procedure sp_helprotect, Line 291
There are no matching rows on which to report.

even though the windows login is registered as a login on the instance.

will this sp work for windows logins?

thanks
LVL 6
anushahannaAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
David L. HansenConnect With a Mentor Programmer AnalystCommented:
Yes.  That is a problem.
0
 
David L. HansenProgrammer AnalystCommented:
Can you post the exact text of your query please.
0
 
anushahannaAuthor Commented:
use master
EXEC sp_helprotect NULL, 'SRBSV\jimw'
0
Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

 
David L. HansenProgrammer AnalystCommented:
Try:
use master
EXEC sp_helprotect NULL, 'jimw'
0
 
anushahannaAuthor Commented:
same error.
0
 
David L. HansenProgrammer AnalystCommented:
In the following link you can see an example identical to yours (ex. B): http://msdn.microsoft.com/en-us/library/ms190310.aspx

Given that, I'd say that the username being used 'jimw' must not be a valid username for 'master'.  Is that your user name?  If not, try the same command using yours instead.
0
 
anushahannaAuthor Commented:
i tried a couple of logins, all same issue.

jimw is valid used in user database.
we use master because that is where the sp is..
0
 
David L. HansenProgrammer AnalystCommented:
Did you verify that 'jimw' has actually performed queries sucessfully on master?  I know it is a pretty obvious question...just want to be thorough.
0
 
anushahannaAuthor Commented:
OK. JimW is a valid use in Tracker database. I do not see him as an user in MASTER, though. is that the problem? it is looking in the wrong place?
0
 
anushahannaAuthor Commented:
Thanks for your help. that was it.
0
All Courses

From novice to tech pro — start learning today.