suser_sname() vs. user_name()
I use suser_sname() to return the name of the user that created the record.
The problem is it returns domain\userid and I just want userid. I thought
of using a substring to get around how the name appears in my forms but I
have old record in the database that are just userid without the domain.
Any suggestions? Should I just go with user_name()? I don?t like the fact
that user_name() returns dbo as the username if you?re the dbo, for example.
--
Message posted via
http://www.accessmonster.com
.
Relevant Pages
- Re: User table updates are recorded as dbo instead of userid
... updates a table, the update is recorded as being done by "dbo" instead of the ... As you may know, the only logins mapped to the dbo user are 1) the database owner, 2) sysadmin role members and 3) dbo aliases. ... table recorded the "Performed By" userid as my Windows ...
(microsoft.public.sqlserver.security) - Re: How to get of last created user using CreateUserWizard?
... How can I use only email instead using UserID? ... RequireEmail="False" and use only UserName, but validation always says ... Prev by Date: ...
(microsoft.public.dotnet.framework.aspnet.security) - more values in listBox
... How to read more then one value into checked listbox? ... I would like to read UserID and UserName, but in listbox I would like to ... I need UserID to Update it in another table after a user select a UserName. ... Prev by Date: ...
(microsoft.public.dotnet.languages.csharp) - Re: ListBox/ComboBox-to-TextBox question
... Just bound the dataset to the ListBox. ... Description, Status, UserName FROM "; ... Password, LoginName, Description, Status, UserName) VALUES (@UserID, ...
(microsoft.public.dotnet.framework.windowsforms) - Re: Adding as option in a multiselect list box
... A part of this I haven't seen described yet is that you need something in the list box After Update event to allow for UserID being zero. ... UserName FROM tblUsers ORDER BY UserName ...
(microsoft.public.access.forms) |
|
