Post reply

Unable to locate table in master db

  • August 29, 2012 at 10:04 am

    #263616

    In sql 2008r2 I am looking for master.dbo.syslogins but unable to find it. Is there another I can use?

  • August 29, 2012 at 10:07 am

    #1531502

    jdbrown239 (8/29/2012)

    In sql 2008r2 I am looking for master.dbo.syslogins but unable to find it. Is there another I can use?

    That is a backward compatibility view, and it is now in the sys schema (sys.syslogins). In master you will want sys.server_principals. In your user databases, sys.database_principals.

  • August 29, 2012 at 10:08 am

    #1531503

    select * from sys.syslogins ?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply