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'

  • vba317 - Wednesday, September 25, 2013 2:51 PM

    Thanks for your patience. I thought I had copied and pasted to avoid errors but I was wrong. The command needs to be exec dbo.sproc_Infmtx_003_MonthlyAR with an underscore after sproc not a . Thanks a million!!

    So the database name was the database to which the session was connected at that time and the procedure belongs to dbo.  Two dots in the earlier command made SQL to take dbo as a database.