.NET     Console.WriteLine( "All Things .NET" );
.NET Nerd Blog Home
11.03.2006

 
Script Multiple Objects in SQL 2005
This was not obvious, and I'll probably forget, so here it is ...

To generate scripts for multiple objects (say, Stored Procs) in SQL 2005:
  • Select the folder such as "Stored Procedures"
  • Hit F7, brings up the summary window
  • Now here you can multi-select, right click, Script as ...
Nice of them to bury that gem in this version.


Comments: Post a Comment

Powered by Blogger