Monday, March 07, 2005

Enterprise Manager Tip

Who knows if I'll post any other tips for SQL Server Enterprise Manager, but this one is so good I had to post it here. Found via Dave Burke via Scott Mitchell:

- From Enterprise Manager, select a table, a view, a stored procedure, a UDF etc - Ctrl-C - Open your text editor (Query Analyzer, NotePad2 etc) - Ctrl-V

Is that cool or what? I have used the All Tasks Generate SQL Script option from the context menu, and also the Script Object To... options in QA before, but to be able to keyboard copy these items makes things a lot more simpler.

No comments: