I am trying to pinpoint an issue a developer ran into.
We have two different SQL Servers both running version
7.00.1063. They also both run on Windows NT 4.
The problem we're having is that we have NT authenticated
accounts on both servers. On the production server, the
suser_name(suser_id('domain\userabc')) function returns
the full domain\userabc name. On the development server,
this function returns only the userabc name.
The problem is, aside from that being a developer coding
against a system "table" such as syslogins - thought its
only a view, that since they went after a column "name"
in syslogins ...