Steven,

Thanks for the tip. The example shows generating the script to a .SQL file. Is there a way to run the newly created file without cutting and pasting the code into the Query Analyzer window?

Thanks

Rex

>See the March 2000 issue of SQL Server Professional by Alan Chorozy titled "Let T-SQL Do the Work for You". There is at least one other article about this over the past 2 years in this magazine. http://pinpub.com.
>
>**--** Steve
>
>>All,
>>
>>I know this message is off topic. I want to generate stored procedures in a SQL Server database. I can do this in Oracle by creating a text files and runnind it via SQLPlus. I would settle for being able to do the same thing here, but what I am looking to do is create a script which would generate Insert, Update and Delete stored procedures given the table name.
>>
>>Any ideas?
>>
>>TIA
>>
>>Rex