Viewing 6 posts - 61 through 66 (of 66 total)
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...
December 28, 2006 at 12:01 am
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...
December 21, 2006 at 6:06 am
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...
December 21, 2006 at 5:44 am
Hi
It returns 8 columns, the same amount as in my table DBBackupInfo.
I have created the stored proc on all the servers.
Anchelin
December 21, 2006 at 3:54 am
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...
December 21, 2006 at 3:10 am
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...
December 21, 2006 at 1:52 am
Viewing 6 posts - 61 through 66 (of 66 total)