I am trying to create MSX ans TSX relationship
MSX is SQL1
TSX is
SQL2 and SQL3
created a job in SQL1 that will run on SQL2 and SQL3
job step is :
create table #sqltest_temp (sqlversion nvarchar(max))
use master
go
insert into #sqltest_temp Select @@SERVERNAME
go
insert into [SQL1].[Databasename].[dbo].[sqlversion_anu]
Select * from #sqltest_temp
go
drop table #sqltest_temp
But when I querry this table [SQL1].[Databasename].[dbo].[sqlversion_anu] it shows only one value whereas should show value for both SQL2 and SQL3 , anyone ...where I am missing ?
You would want to check the job history when things don't seem to be running correctly. Do you have a linked server on SQL2 and SQL3 for SQL1?
Sue