Re: Full Names
Date: Sat, 26 Apr 2003 20:44:38 +0100
It is possible to add an extended property to a user, but not (as far as I
know) with a login!
sp_addextendedproperty 'Full Name', 'John Bell', 'user', 'TestUser', NULL,
SELECT * FROM ::fn_listextendedproperty ('Full Name', 'user', NULL, NULL,
NULL, NULL, NULL)
One possibility may be to use Exchange or ADSI as a linked server to get
Another would be create a extended stored procedure that calls the SDK
function GetUserNameEx with a format of
A third one which may possibly cause administration problems would be have
your own table that you manage.
"Chris George" <firstname.lastname@example.org> wrote in message
> Is there anyway in SQL SERVER to associate a login with a
> person's full name?
- Re: deny select on linked server
... Here is a way to disable one login from using the linked server, while allowing all other logins through. ... -- Grant the excluded login rights to login with a non-existing login and password ... In the radio buttons below, select "Be made using the login's current security context" ...
- Re: Security in Linked Servers
... How to add a linked server login (Enterprise Manager) ... tried setting up the security mapping in several different ...
- Re: Linked Server Connection Error: 18459
... I cannot execute the sqlcmd query against the linked server from sqlServer A to sqlServer B but I can run the linked server query from B to A. ... Login failed for user xxxxx\yyyyy. ... I do notice that the login is trying to connect to the master database via the linked server connection however this login is actually defauted to another user database. ...
- SQL2K - Linked server - Mapping Windows group to a remote login
... My application uses an NT authentification login via a Windows group, ... I've a linked server (Oracle), ...
- Re: linked server login problem... with a particular login... on a particular box
... I don't really need a fix for this anyomore as I've found a workaround and ... I had opened Query Analyzer under ... Neither of which has an existing Login on the Linked Server ...