system table: sysdatabases

• Nsh

  SSCommitted

  Points: 1639

  More actions

  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.

• Pankaj Khanna

  Say Hey Kid

  Points: 707

  More actions

  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...

• Nsh

  SSCommitted

  Points: 1639

  More actions

  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.