Creating a Script from a Stored Procedure

(Ryan Randall) A simple task, I thought, but it took me to some interesting places. The method is broadly this: 1) Create an instance of SQL-DMO SQL Server, and use the script method to save the create table text in a file. 2) Get the text from the file into a sp variable. 3) Delete the text fi

Read More - Register for Free Membership