Re: sysxlogins table with <NULL> entries
- From: Sue Hoegemeier <Sue_H@xxxxxxxxxxxxx>
- Date: Fri, 28 Apr 2006 08:36:42 -0600
Those are for linked servers, remote servers.
Those with the srvid > 0 are for linked server security
mappings. The srvid points to the srvid in sysservers.
I can't remember the specifics for the one for the local
server (srvid = 0) but it was related to remote access as
well.
-Sue
On Fri, 28 Apr 2006 01:31:04 +0000 (UTC), iamsomebody
<iamsomebody2714@xxxxxxxxx> wrote:
Hi all,
running sql server 2000 sp4, viewing the sysxlogins table data, and am wondering
about the three items listed with a <NULL> in the name column, all xstatus
= 192, each has a unique srvid value of 0, 2 or 3.
Looking in the MS tables reference book did not help they don't cover sysxlogins,
googled around but no luck, searched this forum also.
Anyone have any idea what the purpose of these entries are?
Thx
.
- Follow-Ups:
- Re: sysxlogins table with <NULL> entries
- From: gdmoffitt
- Re: sysxlogins table with <NULL> entries
- References:
- sysxlogins table with <NULL> entries
- From: iamsomebody
- sysxlogins table with <NULL> entries
- Prev by Date: Re: Payroll Security
- Next by Date: Re: sysxlogins table with <NULL> entries
- Previous by thread: sysxlogins table with <NULL> entries
- Next by thread: Re: sysxlogins table with <NULL> entries
- Index(es):
Relevant Pages
|
|
