Hi,

I think you can use dynamic SQL

alter proc Test_SP

@dbName Sysname

As

Declare @strSQL Nvarchar(200)

set @strSQL ='Select * FROM ' + @dbName + '.dbo.orders'

exec sp_executesql @strsql

Go

Regards,

Ahmed