Home Forums SQL Server 7,2000 T-SQL Run same SQL or Stored Proc for multiple databases RE: Run same SQL or Stored Proc for multiple databases

  • October 21, 2011 at 2:34 am

    #1397791

    Create "sp_" procedure in master database.

    Put your code in there.

    Then use handkot's approach to execute that procedure for each database.

    _____________
    Code for TallyGenerator