Re: Full Names
From: John Bell (jbellnewsposts_at_hotmail.com)
Date: 04/26/03
- Next message: Chris: "newbie SQL question"
- Previous message: Dejan Sarka: "Re: DATA STRUCTURE VISIBILITY"
- In reply to: Chris George: "Full Names"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Sat, 26 Apr 2003 20:44:38 +0100
Hi Chris
Some thoughts...
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,
NULL
GO
SELECT * FROM ::fn_listextendedproperty ('Full Name', 'user', NULL, NULL,
NULL, NULL, NULL)
GO
One possibility may be to use Exchange or ADSI as a linked server to get
information
Another would be create a extended stored procedure that calls the SDK
function GetUserNameEx with a format of
NameDisplay .
A third one which may possibly cause administration problems would be have
your own table that you manage.
John
"Chris George" <christina.george@phh.com> wrote in message
news:05f701c30a86$9bcc2a90$a001280a@phx.gbl...
> Is there anyway in SQL SERVER to associate a login with a
> person's full name?
- Next message: Chris: "newbie SQL question"
- Previous message: Dejan Sarka: "Re: DATA STRUCTURE VISIBILITY"
- In reply to: Chris George: "Full Names"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
