>So I could in fact hardcode the table names, but I would not be able to hardcode the database names. So, as such I would assume I would agian lose the benefit of the SP????
>
>Thanks again
Yes. When you specify the table name as owner.tablename in your SP, if you don't specify the database, it assumes the current one. If it isn't supposed to be the current one, you need to specify it using the database.owner.tablename syntax. Because a variable can't be used, you have to dynaically build the SQL string and then execute it.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao