Home Forums SQL Server 2005 SQL Server Newbies SQl 2005 Could not locate entry in sysdatabases for database 'dbo' RE: SQl 2005 Could not locate entry in sysdatabases for database 'dbo'

  • September 25, 2013 at 2:42 pm

    #1653354

    There's your problem

    exec dbo.sproc.Infmtx_003_MonthlyAR

    That states that the database name is dbo, the schema is sproc and the procedure name is Infmtx_003_MonthlyAR. Since you're getting errors, that's obviously not the case, so specify the correct database and schema names for the procedure

    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