Could not locate entry in sysdatabases for database '%.*ls'. No entry found with that name. Make sure that the name is entered correctly.
This error occurs when attempting to change database context (with a USE statement) to a database that does not exist or when the default database established for a login does not exist. In the latter case, the user login then attempts to access the master database.
To obtain a list of databases, execute sp_helpdb or issuing this query:
SELECT name
FROM master..sysdatabases
The list returned will contain the databases that exist on the Microsoft® SQL Server™ installation. Either create a missing database or connect to an existing one. To correct login-level errors, it may be necessary to execute sp_defaultdb.
Errors 1 - 999 | sysdatabases |
sp_defaultdb | USE |
sp_helpdb |