IS THIS SHOULD BE IMMEDIATELY AFTER THE UPGRADE TO 2005(COMPATIBILITY IS IN 80) OR AFTER CHANGING THE COMPATIBILTY TO 90.

• madhu-686862

  SSChampion

  Points: 10707

  More actions

  April 3, 2009 at 3:55 pm

  #208151

  hi,

  In earlier versions of SQL Server, the INFORMATION_SCHEMA.SCHEMATA view returned all databases in an instance of SQL Server. In SQL Server 2005, the view returns all schemas in a database, which complies with the SQL Standard.

  Corrective Action

  Modify your application to reference the sys.databases catalog view to return all databases in an instance of SQL Server

  IS THIS SHOULD BE IMMEDIATELY AFTER THE UPGRADE TO 2005(COMPATIBILITY IS IN 80) OR AFTER CHANGING THE COMPATIBILTY TO 90.

  Please clarify me..

• maechismo_8514

  SSCoach

  Points: 17510

  More actions

  April 3, 2009 at 6:55 pm

  #971931

  If you want to return all the databases in 2005 query sys.databases view.

  Change the compatibility mode to 90.