Post reply

system table: sysdatabases

  • September 28, 2006 at 3:43 pm

    #367505

    Hi,

    Some of the entries in sysdatabases - the version column contains NULL while others are 539.

    Why does the version column show NULL (as its a computed column in sysdatabases) when the database is ONLINE status.

    Plz let me know.

    Thanks.

  • October 2, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • October 4, 2006 at 4:26 am

    #664050

    Have you restored the database or created on this server only?

    Pankaj Khanna
    Database Administrator - SQL Server 2000

    Keep hope to keep you intact...

  • October 4, 2006 at 11:08 am

    #664135

    Hi,

    It was restored - and it was showing null because the 'auto-close' option was selected.

    Thanks.

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

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