Pass in Parameter Sp

• joemai

  Hall of Fame

  Points: 3496

  More actions

  April 13, 2006 at 4:34 pm

  #117031

  Hi All,

  Please help.  I tried to build a sp so that user can pass-in database name and my sp will allow them to query in the database that they select.  How can I do that in the sp.  I have about 50dbs, and those 50dbs have the same table name tbl_email. 

  I will be very  appreciate for any help.

  Thanks

  Minh Vu

• Antares686

  SSC Guru

  Points: 125444

  More actions

  April 13, 2006 at 5:55 pm

  #632547

  Your best bet is to put the SP in each DB and tell them to reference and execute by running this way

  dbname.dbo.SPName

  The other way is dynamic SQL and you end of giving the very permissions you want to avoid on the table.