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 20, 2011 at 11:45 pm

    #1397738

    exec sp_MSforeachdb @command1 = 'use [?]; SELECT COUNT(*) FROM MyLeads WHERE active = 1'

    I Have Nine Lives You Have One Only
    THINK!