I have one query regarding dynamic database.

Hope below query will help.

===================================

create table #temp

(

empcode int

)

EXECUTE master..sp_MSForeachdb '

USE [?]

IF ''?'' <> ''master'' AND ''?'' <> ''model'' AND ''?'' <> ''msdb'' AND ''?'' <> ''tempdb''

BEGIN

IF (EXISTS (SELECT *

FROM INFORMATION_SCHEMA.TABLES where TABLE_NAME = ''rostering'' and TABLE_SCHEMA=''tna'' ))

BEGIN

insert into #temp

select distinct empcode FROM tna.rostering

end

END

'

declare @empcode int

select * from #temp where empcode=@empcode

0

Yes Manish.

0

Hi Krunal,

Are you trying to fetch record from table tna.rostering which is exists in multiple database?

Thanks,

Manish

0