Post reply

Could not locate entry in sysdatabases for database

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

  • 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

  • December 15, 2010 at 8:48 am

    #1262930

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

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

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