Needed Features In Visual Studio 2008 Server Explorer

I’ve been trying to utilize the Server Explorer in Visual Studio 2008 for my SQL Server programming tasks like table maintenance and stored procedure authoring.  However this new workflow is not as productive as using SQL Server Management Studio.

Viewing Columns

A quick glance at the below images shows that Visual Studio 2008 does not display the same MUCH needed column information.  Yes, when you click on a column, the Visual Studio 2008 Properties Window displays this and more data.  However, when you click back to the code window or anywhere else, the Properties Window data changes.  Also, having to click on a column to see its information slows the developers workflow down.  Please display at least the same information that SSMS does for a column.

SQL Server Management Studio Visual Studio 2008
visualstudioone visualstudiothree

Copying Column Name(s)

Another very missed piece of functionality is the ability to copy one or more column names from the above displayed list into either a stored procedure or code window.

In SSMS the developer can drag the Columns folder into a code window and all column names are copied into the code window separated by commas.  Visual Studio 2008 does not have this.

In SSMS the developer can drag the column name into a code window and the column name is copied into the code window.  Visual Studio 2008 does not have this.

This is an invaluable time saver and ensures accurate copying of column names into code or stored procedures.

Viewing Stored Procedure Declarations

A look at the two below images shows that Visual Studio 2008 does not display the same MUCH needed parameter information.  This functions that same way and has the same limitations at the above table columns.

SQL Server Management Studio Visual Studio 2008
visualstudiotwo visualstudiofour

Help Get This Fixed

I have posted this problem on Microsoft Connect here: https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=341791

Please rate this issue on Microsoft Connect so that it will get corrected. 

VS2005 had the same issue and I wish I would have known how to report problems like this long ago.

Close

I was going to write this up on the Visual Studio 2008 forums, but you can’t post images (which is a very good feature) so I wrote it up here where I could post the images and wrote a text only version that you can read here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3281961&SiteID=1.

I do like the fact that many features have been moved into Visual Studio (STRONGLY wish SSMS could debug stored procedures) but if I’m being asked to alter my workflow, then I should at least have the same features that the other tool does.

Microsoft, please update Visual Studio 2008 with these features.

Have a great day and thank you!

Just a grain of sand on the worlds beaches.

Comments are closed.

Follow

Get every new post delivered to your Inbox.

Join 240 other followers