Stored Proceduresgreenspun.com : LUSENET : SQL Server Database Administration : One Thread
We need to make changes onto quite a number of stored procedures but all these have NO text file copies. Is there a scripted method where we can output the complete contents of each stored procedure from the SQLServer 7.0 database onto an individual text file? We're using a utility called u/win which has various commands that work on text files. Stretching my inquiry further, is there a scripted method that can output the complete contents of certain database objects on text files?
Thanks a lot again for your help!!
-- Anonymous, January 21, 2000
From the Enterprise Manager, click on the Tools... menu and select Database Scripting...
From there you may select the objects (including stored procedures) to be scripted (that is, output to a *.sql file).
Hope this helps,
-- Anonymous, January 25, 2000