ifmanish the use only remains in effect for the duration of the EXECUTE process. Any code outside this will remain in the same DB context.
However to save soem developement hassels and to get to work as you need try something like this.
EXEC sp_MSForEachDB '
USE ?
GO
yourcodehere, --keep in mind double all single quotes to work properly.'
Also you may want to use the fully qualified name if possible which would look sorta like this.
EXEC sp_MSForEachDB '
DROP TABLE ?.dbo.tempimp'
The key is the ? with the system SP is replace with the database name and the code is executed. There is also an sp_MSForEachTable that works similar but they cannot be used together.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)