I am trying to discern the various aspects of the t sql behind this stored proceedure. Has anybody already broken the sp down to the two different SELECT's to get the two result tables? If not, can anybody help me begin to do this?
-Kyle
I tryning to program (in VB.net) sp_helplogins, assuming this is the correct sp to use to determine who is currently logged onto the database.
Ive already programmed, in VB.net, the execution of sp_helpuser and get correct results, but don't seem to be able to program sp_helplogins.
Any help would be appreciated.
Thanks,
/jerry
I am trying to send the output from sp_helplogins to a table, however, whenever I run it the results come in two windows...Does anybody get what I mean? Generally, I would just create the table, then send the results to the table, however, there are two outputs from the stored proceedure, with me wanting both...What can I do to send these results to a table? Please run sp_helplogins to get a better understanding of what I mean. Thanks in advance for any help.
-Kyle
We're runnning SP5A, and I logon to an a/c which map to the public group in the master db, if I execute sp_helpprotect on stored procedure sp_helplog and sp_helplogins, both of them indicates permissions to execute is granted to public.
Owner Object Grantee Grantor ProtectType Action Column
----- ------------- ------- ------- ----------- ------- ------
dbo sp_helplogins public dbo Grant Execute .
I have no problem in executing sp_helplog, however, when I tried to execute
sp_helplogin, I got
"Msg 15003, Level 16, State 1
You must be System Administrator (SA) to execute this stored procedure."
Anyone knows why ??? I thought the sysprotects system table is where to control permission to execute stored procedure, is this an exception...
Thanks.
Hello,
I have a user u with server role security admin. I use sql2000. I go the query analyzer and call sp_helplogins. Now I get all the logins with attached users. Perfect! When i'm in my sourcecode(C++ and i use sqloledb.dll) and I make a call to sp_helplogins I get now results. Why is this? When I also give user u the fixed server role system admin it also works in my code. But in sql server help file it says the following:
Permissions
Only members of the sysadmin and securityadmin fixed server roles can execute sp_helplogins.
So it should be enough to have only one of these two roles. Does anyone have a clue why I don't get result when I call sp_helplogins from my code. I don't want to give system admin tights to user u.
beforehand thanks
Coen Dunnink
The Netherlands
Could someone help me understand the following code from the sp_helpsyslogins
stored procedure?
SELECT
@charMaxLenLoginName =
convert ( varchar
,isnull ( max(datalength(LoginName)) ,9)
)
,@charMaxLenDBName =
convert ( varchar
,isnull ( max(datalength(DBName)) ,6)
)
,@charMaxLenUserName =
convert ( varchar
,isnull ( max(datalength(UserName)) ,8)
)
I do not understand what the last parameter of the convert function
(the
9, 6, & 8) represents nor how it's value gets determined.
Could you possibly shed some light on this for me. I would like to
modify this procedure to also include group name for each login with in
a
database.