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