I have a database (say database1). In this database I have a stored procedure (say sp1). The stored procedure selects data from a table (say table1). Instead of selecting data from table1 database1, I want to select the data from table2 database2. But the stored procedure will be in database1. Is this feasible? If it is how do I do it? Any help will be appreciated.