Hi,

I want to access a database table from one db partition into a stored procedure of another db partition.

I have declared a local variable in the stored proc accessing the table to set it to the appropriate partition at runtime depending on the environment in which the stored proc will run.

So Basically my issue is that I have a Stored Proc in on DB Partition which has to acess a Table which sits in a different Partition.How Do I make the Stored Proc acess this Table.


Thanks