Post reply

What diference between sys.sysxyz and sys.xyz

  • May 10, 2011 at 12:40 am

    #239330

    What diference between sys.sysxyz and sys.xyz

    select * from sys.sysdatabases

    select * from sys.databases

    Thanks

  • May 10, 2011 at 12:49 am

    #1322114

    sys.databases is a new catalogview and sys.sysdatabases is for backward compatibility for SQL Server 2000 and this will be remove in the future release

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

  • May 10, 2011 at 1:04 am

    #1322122

    Thanks...

    Thanks

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

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