April 24, 2009 at 5:03 am
Hello,
I am completely new to this so please bare with me 🙂
I have Sql Server 2008 Developer Edition installed on my home PC, I am the only person using it (trying to understand database design and implementation). I have a login that I created when I installed the product ("myDomain\Robert"), and I have a database called MovieRental that I've added schemas and tables to (For example: Inventory.Movie, that contains details about a particular movie).
When I click the "New Query" button to begin coding against the database using the schema.TableName (Inventory.MovieRental), I get a red squiggly line and the tooltip displays the following message:
[highlight=#ffff11]The specified schema name "Inventory" does not exist or you do not have permissions to use it[/highlight]
If I run a script it works, but I still have the squiggly line under the schema name.
What I don't understand is how do I log into the server and then use a user account that has access to a particular schema?
FYI: I can see the schema and I can see the user has been created successfully.
April 26, 2009 at 4:15 pm
Hi Robert,
That red line states the Cache for the Intellisense is not up-dated. When you create a table, or objects the intellisense does not update all the time. You have to press CTRL+SHIFT+R to update intellisense manually.
I am not sure what triggers automatic updates... I have yet to find one. Maybe just opening a new query to the database?
Thanks.
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply