Matt Crowley (1/21/2014)
It is most likely that your login is not defined as a user in the Cheese database, or a member of a group that is defined as a user in the Cheese database. Can you run the following?
use CheeseIf not, then you are definitely not defined in the Cheese database.
To simplify permissions (and referential integrity, and recovery), have you considered moving the tables from the Cheese database into a central database as a schema, rather than as a standalone database?
Got it, as it frequently is, the problem turned out to be a simple typo.
Thanks for the assistance!
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams