XP_logininfo

Hello,

I read about limitations on running the Xp_logininfo in SQL 2005. In fact, from: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/ee7162b5-e11f-4a0e-a09c-1878814dbbbd.htm

I read

Note:

In earlier versions of Microsoft SQL Server, permission to executexp_logininfo can be granted to users. In SQL Server 2005,xp_logininfo can be run only by an administrator.

Nevertheless, I made a test and succeeded to grant the rights to a user which is not an administrator, have you any ideas on the reason?

Thank you very much

[738 byte] By [VaniaB] at [2007-12-24]
# 1

hi,

this will not help you, but I experienced the same behavior, it seem that the books online are not correct or SQL Server 2005 has a bug...

Bye

Marco

MarcoBergonzini at 2007-10-8 > top of Msdn Tech,SQL Server,Transact-SQL...
# 2

I was able to grant execute rights, and a user could execute it, but I didn't get results. Do you get results?

Either way BOL should be changed to reflect what exactly will occur...Consider posting feedback from the link in BOL. They are very courteous and will likely get back to you pretty soon after you email them your comments.

LouisDavidson at 2007-10-8 > top of Msdn Tech,SQL Server,Transact-SQL...

SQL Server

Site Classified