syslogins and sysxlogins error
In our project, the database was upgraded from sqlserver 2000 to sqlserver 2005.
In that there is an old job which used to get newly created logins from joining the syslogins and sysxlogins table by joining the sid.
But after moving to sqlserver 2005 , the job is failing since there is no sysxlogins tabe.
So what is the equivalent to sysxlogins in sqlserver 2005.
|
