SQL Server Management Studio Archives - Page 48 of 48

SQL SERVER – 2005 Query Analyzer – Microsoft SQL SERVER Management Studio

April 23, 2007

SQL Server Management Studio, SQL Utility

Following may be very simple to some and helpful to other type of question. I have seen this in my server log as well as this has been always first question in my Developer Team. Where is SQL SERVER 2005 Query Analyzer? SQL SERVER 2005 has combined Query Analyzer and…

SQL SERVER – Query Analyzer Short Cut to display the text of Stored Procedure

January 30, 2007

Pinal Dave

SQL Tips and Tricks

SQL Server, SQL Server Management Studio, SQL Shortcut, SQL Stored Procedure

This is quick but interesting trick to display the text of Stored Procedure in the result window. Open SQL Query Analyzer >> Tools >> Customize >> Custom Tab
type sp_helptext against Ctrl+3 (or shortcut key of your choice)