I get the following error:

SQL 2005 components not installed on computer or doesn't have administrator rights.

I do have rights and if i didnt have the 2005 componenets, would...

Hi John

It's working now, THANK YOU so much!! The PRINT statement showed me where the error was. THANKS!!!

The columns of the sp on those two servers, didnt match columns of...

Hi

See below

use DBA_Reports

insert into dbo.DBBackUpInfo

([ServerName],[DatabaseName],[BackupStartDate],[BackupEndDate],[BackupSize],[BackupSizeMB],[BackupSizeGB],[BackupStatus]) SELECT * FROM OPENQUERY (BEPTDR01,' SET FMTONLY OFF exec master.dbo.sp__DBBackupInfo')

(24 row(s) affected)

use DBA_Reports

insert into dbo.DBBackUpInfo

([ServerName],[DatabaseName],[BackupStartDate],[BackupEndDate],[BackupSize],[BackupSizeMB],[BackupSizeGB],[BackupStatus]) SELECT * FROM OPENQUERY (BEPCBT01,' SET FMTONLY OFF exec...

Hi

It returns 8 columns, the same amount as in my table DBBackupInfo.

I have created the stored proc on all the servers.

Anchelin

Hi John, THANKS for sticking with me!!

result:

(24 row(s) affected)

(10 row(s) affected)

(10 row(s) affected)

(5 row(s) affected)

Msg 120, Level 15, State 1, Line 3

The select list for the INSERT statement contains...

I did... ok here is the script:

DECLARE @count1 int

DECLARE @count2 int

DECLARE @ServerName varchar(300)

DECLARE @Query1 nvarchar(2000)

DECLARE @Query2 nvarchar(2000)

DECLARE @Query3 nvarchar(2000)

set @count1 =0

set @count2 =(Select max(ServerID) from dbo.Server_Lookup where Status = 'Active')

While...