Tools - Daniel's blog

Browse by Tags

Scripting objects in SQL Server 2005: DROP it already
08 August 08 06:14 PM | DanielVanWyk | 1 comment(s)
I had to create scripts for a couple of Stored Procedures today.  SQL Server Management Studio provides that functionality:  You can right-click on an object (Stored Procedure, Table, etc) and choose Script As and there you go.  You can also right-click on the database and use the scripting wizard as explained in How to: Generate a Script (SQL Server Management Studio) on MSDN. So, then why the reason for the post?  In Enterprise Manager (in the bygone days of SQL Server 200)...