Welcome to weblogs.com.pk Sign in | Join | Help

sysxlogins

SQL Server 2000 had certain system tables; using them was not encouraged and neither were they documented publicly. However no one was stopping you to use it and people have used it to do different things. I myself have used few of them; and today I discovered a “breaking change” between SQL 2000 and SQL 2005 regarding sysxlogin.

Technically its not a breaking change; as such objects were not meant for our use </smile>

If you have used something like

select name from master.dbo.sysxlogins

You will now need to use

select name from master.sys.syslogins

Published Tuesday, February 07, 2006 5:47 PM by khurram
Filed under: ,

Comments

No Comments

New Comments to this post are disabled