Change code in multiple stored procedures

Hi,

    I have many stored procedures that have the server name hard-coded for bcp out purposes.  Is there a was to update all of these at one time, or am I stuck opening each one up seperately?

Thanks

Pam

  

October 28th, 2013 11:00pm

You can generate the ALTER scripts for all your stored procedures and then search-and-replace.

David

Free Windows Admin Tool Kit Click here and download it now
October 28th, 2013 11:07pm

Hi Please get all User defined sps from database through sys.objects and just alter all of one.

Regards

Damodar

 
January 31st, 2015 10:20am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics