Stored procedures with table parameter

• K V Siva

  SSC Journeyman

  Points: 81

  More actions

  January 18, 2006 at 11:53 pm

  #188920

  Hi all,

  I have created a SP in master database that requires table name as a parameter. But I am worried, it give a error " obj not found" if the table belongs to other database...

  For this SP to work successfully against all the tables.. do i need to deploy therm each and every DB in my server or is there any way out..

  How can I implement this...??

  Thanks in advance...

   

• MVDBA (Mike Vessey)

  SSC-Insane

  Points: 21797

  More actions

  January 19, 2006 at 3:15 am

  #615719

  can you add an extra parameter for the database name?

  then your sql could refernce the full name of the table. e.g

  database.tableowner.tablename

  or could you post your stored procedure so we can see if there is an easy way

  MVDBA