multiple DB's

• Mike Levan

  SSChampion

  Points: 14201

  More actions

  October 30, 2007 at 6:40 am

  #61396

  Can I run a store proc residing on database A in multiple databases where I can select the DB name as parameter in my proc and I will be using the DBparameter for queries inside the proc.

• Dinakar Nethi-176633

  SSCarpal Tunnel

  Points: 4689

  More actions

  October 30, 2007 at 10:07 am

  #746732

  check out the undocumented proc sp_MSForEachDB

  ******************
  Dinakar Nethi
  Life is short. Enjoy it.
  ******************