Re: 2 sa entries in sysxlogins
From: Gert (gert_at_gert.com)
Date: 08/29/03
- Next message: Jasper Smith: "Re: beginers encryption question"
- Previous message: Russell Fields: "Re: need help with login permission"
- In reply to: Jasper Smith: "Re: 2 sa entries in sysxlogins"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 29 Aug 2003 07:34:43 -0700
Thanx Jasper
>-----Original Message-----
>Have a look at the srvid column, when it's NULL that's
your local instance
>sa login, any other value indicated a linked server login
mapping
>
>--
>HTH
>
>Jasper Smith (SQL Server MVP)
>
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>
>"Gert" <deswardtg@excite.com> wrote in message
>news:0ac301c36d5d$bb6dfec0$a501280a@phx.gbl...
>On 2 of my servers, I have 2 entries for the sa user in
>the sysxlogins table. Whould anybody know why?
>
>Regards
>Gert
>
>
>.
>
- Next message: Jasper Smith: "Re: beginers encryption question"
- Previous message: Russell Fields: "Re: need help with login permission"
- In reply to: Jasper Smith: "Re: 2 sa entries in sysxlogins"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
