Could not retrieve the schema
mipe10
Posts: 72 New member
When changing the database context from one database to another the user gets this error "SQL Prompt could not retrieve the database schema;"
Does the user has to have some kind of schema rights in order for SQL prompt to work? The tool obviously needs to parse the schema when you change database context!?
Does the user has to have some kind of schema rights in order for SQL prompt to work? The tool obviously needs to parse the schema when you change database context!?
Comments
Please see this thread for answer to your question:
http://www.red-gate.com/messageboard/vi ... hlight=dbo
Regards,
Tilman