Instead of dynamic SQL, I recommend conditional execution like this:

alter proc Test_SP

@dbName Sysname

As

if @dbName = 'Database1'

begin

select * from Database1.dbo.TableName

end

else if @dbName = 'Database2'

begin

select * from Database2.dbo.TableName

end

Go