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
Technology Tips and News
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
You can generate the ALTER scripts for all your stored procedures and then search-and-replace.
David
Hi Please get all User defined sps from database through sys.objects and just alter all of one.
Regards
Damodar