• Beatrix Kiddo (4/11/2014)


    Posted too soon!

    They log into SSMS as DomainName\Username yes? If you check under Security > Logins > DomainName\Username right-click, Properties, what have they got under Server Roles? And what have they got under User Mapping (i.e. are there any databases they're mapped to?)

    Under server roles: public and sysadmin

    Under user mapping: public is checked down the bottom, and a smattering of DBs are checked up top: all but one of them has user as dbo and default schema as dbo. The auslander is domain\user and default schema dbo.

    Thanks