I originally posted this in another forum a few days ago but no one has responded. This forum looks more appropriate to the issue though since it related to IDE / security rather than code:

I am studying for the 70-315 exam and going through a chapter on Data Binding (and intro to Databases using SQL Server, or MSDE in my case)

The current example I am working on implies that if I right-click on the "Views" node in Server Explorer I will have the option to add a "New View" to the Northwind database . However, the only options are "Refresh" and "Properties".

For the time being, I have managed to get around it by installing the evaluation version of SQL Server and using Enterprise Manager to build the new View required by the example program, but I still do not know why I cannot complete this task within Visual Studio. I am guessing that my permissions are not setup correctly and thus VS is filtering (disallowing) accesss to the "New View" command?

Any ideas on fixing this problem? (Note: I am using Visual C#.net 2003 Standard)

I am not 100% sure, but I believe the ability to add / modify things like that is only available when you're connected to a local SQL Server and not to one on a local machine?

Would that make sense? After you installed SQL Server did it work then? (assuming you installed SQL Server locally that is)

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Can you give me more details on how to solve this issue? I am having the same problem with this book. I installed SQL 2000 Developer locally.

Thanks.