Query Analyzer usage

9 Dec 2005 6:58 PM

=== Steve L ===

In SQL 2000, one can quickly generate the code for a table or stored
procedure script by high lighting a table or a stored procedure (ctrl
+ c), then switch to a blank page in Query Analyzer (or any text
editor) and paste it (ctrl + v). How this can be accomplished in SQL
2005?

Yes, right click the object and choose the script out option provides a
similar functionality in 2005, but there's no match of the speed and
convenience of the previous method.

Thank you

9 Dec 2005 9:26 PM

Aaron Bertrand [SQL Server MVP]

Right-click the stored procedure name, and either Modify (will open a new
window with an ALTER script) or look at the Script Stored Procedure as >
menu.

For a table, right-click and Script Table as > ...

Show quote

"=== Steve L ===" <steve.***@powells.com> wrote in message
news:1134154697.216971.308890@z14g2000cwz.googlegroups.com...
> In SQL 2000, one can quickly generate the code for a table or stored
> procedure script by high lighting a table or a stored procedure (ctrl
> + c), then switch to a blank page in Query Analyzer (or any text
> editor) and paste it (ctrl + v). How this can be accomplished in SQL
> 2005?
>
> Yes, right click the object and choose the script out option provides a
> similar functionality in 2005, but there's no match of the speed and
> convenience of the previous method.
>
> Thank you
>

9 Dec 2005 9:38 PM

Trey Walpole

i've always found the right-click edit(2k) [rtclick+E]/modify(2k5)
[rtclick+Y] faster than copy/pasting myself. although the ability to
drag-drop between EM and QA and get this result for multiple objects is
nice. and the ability to script multiple objects to multiple files.

=== Steve L === wrote:
Show quote

> In SQL 2000, one can quickly generate the code for a table or stored
> procedure script by high lighting a table or a stored procedure (ctrl
> + c), then switch to a blank page in Query Analyzer (or any text
> editor) and paste it (ctrl + v). How this can be accomplished in SQL
> 2005?
>
> Yes, right click the object and choose the script out option provides a
> similar functionality in 2005, but there's no match of the speed and
> convenience of the previous method.
>
> Thank you
>