I have a stored procedure wich will work with two different user defined databases. i want to know  how i can switch two diffrent databases in my stored procedure

i tried something like this

use @source_db

and

exec ('use ' + @source_db)

both are not working. any one have idea is highly appreciated

thanks in advance

hi shamraj,

do you need to use SP and change with "use"? because you can use two or more DB at same time. 

can you write your sample may I help.

VI