MS SQL Server - xp

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

xp_logininfo

Elmer Miller

2006-01-26, 4:53 pm

I have SQL 2000 SP4
I'm having problems with error 8198 when scheduling jobs owned by certain
users. It seems to be a case of case sensitivity. I can reproduce the error
by running: xp_logininfo 'DOMAIN\SQL-Service'
.... but this works: xp_logininfo 'DOMAIN\sql-service'
For some reason the users available in the 'Owner:' drop down box on the
General tab of the Job shows SQL-Service not sql-service.
If I run xp_logininfo with no parameters I get a row for DOMAIN\SQL-Service

Also strange... I looked at the source for xp_logininfo and it executes a
line like this:
select distinct domain+N'\'+name, sid, sidtype

from OpenRowset(NetUserGe
tGroups, @acctname)

I cannot get this openrowset to work from query analyzer. I get: Incorrect
syntax near the keywork "OPENROWSET"

Sponsored Links