Could not locate entry in sysdatabases for database

• ramadesai108

  SSChampion

  Points: 10609

  More actions

  December 15, 2010 at 8:36 am

  #144025

  I am trying to run the following and I get the error "Could not locate entry in sysdatabases for database".

  sp_msforeachdb 'USE ?;select distinct db_name()'

  I know that one of the db name is longer.

  Any ideas?

  Thanks.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  December 15, 2010 at 8:44 am

  #1262927

  Does it change anything if you wrap the dbname in [] in the use statement?

  sp_msforeachdb 'USE [?];select db_name()'

  p.s. No need for distinct, you're selecting a single constant value.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• ramadesai108

  SSChampion

  Points: 10609

  More actions

  December 15, 2010 at 8:48 am

  #1262930

  Adding brackets around "[?]" was a common sense and I am missing it. Thank you very much.