sysxlogins table with <NULL> entries

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

iamsomebody - 28 Apr 2006 02:31 GMT

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

Reply to this Message

Sue Hoegemeier - 28 Apr 2006 15:36 GMT

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

>Hi all,
>
[quoted text clipped - 8 lines]
>
>Thx

Reply to this Message

gdmoffitt@gmail.com - 28 Apr 2006 17:22 GMT

Thanks Sue, I looked in sysservers and the srvid of course is the
instance itself, then the 2 and 3 are entries due to links..thks

Reply to this Message