I am working through a book about setting up a database, though i'm doing it slightly differently, using a sql server database on a remote server rather than the local sql server express database shipped with visual studio.
everything has been going fine until i've reached a part where they want to add a database diagram to the existing database. they talk about right clicking the database diagram node, and selecting add, but for some reason there is no database diagram node, so i can't do it this way. the book also says using the data>add new>diagram from the menu, but when i do this i either have no diagram option (when i have no table opened) or else the diagram option is greyed out and unselectable (when i have a table opened).
any ideas on how i can add a database diagram?
dc
You need to install the Express Advanced locally and import your database to create the diagram because you cannot create a database diagram without System Admin permissions and you are not a System Admin in your hosting company's server. Hope this helps.
http://msdn.microsoft.com/vstudio/express/sql/download/
|||thanks
No comments:
Post a Comment