The Old Joel on Software Forum: Part 3 (of 5) - Query Analyzer in Visual Studio .net

Query Analyzer in Visual Studio .net

I had heard that there is something like query analyzer and enterprise manager built into Visual Studio .net. All I've been able to come across is a cut down Ent. manager.

Is it really there? Where? I have the client tools but I don't want to install them becuase that would require jumping through the IT department's hoops.

dot net Noob
Tuesday, January 6, 2004

I had heard the same think... about the next version of VS.NET, so maybe it is a release away.

still waiting after all these years
Tuesday, January 6, 2004

Hi Noob,

Use the Server Explorer window in Visual Studio .NET to navigate to a random stored procedure in your favourite SQL Server database. Then double-click on the stored proc to view the SQL source within a Visual Studio window.

Now you should find that you have a new Database menu. The most interesting option on this menu is the one entitled "Run Selection". The Visual Studio IDE normally allows you to execute only a complete stored procedure, but this option allows you to write an ad hoc script, place the script in any window that displays a stored procedure, select the script by highlighting it, and then execute it.

So this works something like Query Analyzer, and is useful for testing ad hoc scripts or checking part
of a stored procedure.

HTH,

Mark
-----
Author of "Comprehensive VB .NET Debugging"
http://www.apress.com/book/bookDisplay.html?bID=128

Mark Pearce
Tuesday, January 6, 2004

Mark,

Thanks - I guess that is the answer. It will be useful for queries, but I'll write a little program to allow me to do everything else.

dot net Noob
Thursday, January 8, 2004