I've searched high and low for the answer to this and can find nothing on it. I have installed VS 2010 pro edition on a virtual machine running MS XP Pro. After connecting to my database, I can see all the tables, stored procedures, and functions just fine in the list. However, when I rick-click on any of them, the options to create new/edit/run any of them are missing.
This is not the first time I've set up VS 2010. I got a new laptop so reinstalled everything. I changed no settings the first time I've set this up, and none this time. I set up the connection to the databases the same way each time, and even looked at my old connection settings while I set up this installation. The old installation had all of the right-click options, but this one does not. I have tried going to Tools -> Import and Export Settings -> Reset all settings
and tried General Development Settings
, Visual C# Development Settings
, and Web Development
as the default collection of settings. None of these worked.
I've looked through the settings and found nothing for the right-click menu. It almost seems as if the database connection is open in a "read only" mode, but there doesn't seem to be a setting for that, so I don't think that is the case. If anyone knows of any way to get these options to show up, I would greatly appreciate the input. Thanks in advance.