• Mackers (2/26/2013)


    The only ways I can think of doing this are by generating & running dynamic SQL statements either through a stored proc (passing the table names as variables) or a task script (again passing the table names as variables)

    Mack

    Or write all of the update logic in a single stored proc which encapsulates the cross-database logic and just call that - nothing dynamic required.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.