Posts tagged Automation

Altering Stored Procedure Families Programatically

Reprinted with permission from owner. Original at http://nlsimmons.com/SQLScraps/

Alter every stored procedure in a database that fits a given criteria

Recently I had to search for, and update, hard-coding server references for every stored procedure in a database. This amounted to altering over 60 stored procedures. Instead of going through each stored procedure, one-by-one, I used the following code to accomplish the task:

Keep reading…

We're Here To Help.

    Database problem? Tell us a little bit about it.

    Name*

    Email*

    Subject

    Message*

    captcha

    * Required