I am curious to know if anyone has done this.
We currently have two SQL Server 2005 Servers. We would like to replicate the dynamics and our data to the other server. Currently the only way I can accomplish this is by
snapshot replication (as not all tables have primary keys).
It keeps failing though, I am getting the following errors:
Agent message code 213. Insert Error: Column name or number of supplied values does not match table definition.<nl/>2007-02-04 07:00:38.401 Category:COMMAND<nl/>Source: Failed Command<nl/>Number: <nl/>Message: create procedure "dbo"."AddGPSSQLErrorCode" @cName char(30)<c/> @cText char(255) as declare @iCode int begin transaction select @iCode = max(CODE) + 1 from GPS_SQL_Error_Codes with (UPDLOCK) insert into GPS_SQL_Error_Codes values ( 0<c/> @iCode<c/> @cName<c/> @cText) select @iCode commit transaction <nl/><nl/>2007-02-04 07:00:38.416 Category:NULL<nl/>Source: Microsoft SQL Native Client<nl/>Number: 213<nl/>Message: Insert Error: Column name or number of supplied values does not match table
'glChangeDistAcca44d185_882.sch'<nl/>2007-02-05 07:33:54.638 Agent message code 213. Insert Error: Column name or number of supplied values does not match table definition.<nl/>2007-02-05 07:33:54.732 Category:COMMAND<nl/>Source: Failed Command<nl/>Number: <nl/>Message: create procedure "dbo"."glCLAccountMSTR" @I_cUser_ID char(15) = NULL<c/> @I_tMCRegistered tinyint = NULL<c/> @I_cReporting_Currency char(15) = NULL<c/> @I_cAccount_MSTR_Table_Name char(255) = NULL<c/> @I_cFixed_Alloc_Table_Name char(255) = NULL<c/> @I_cSeg_Desc_Table_Name char(255) = NULL<c/> @I_cSeg_Desc_Temp_Table char(30) = NULL<c/> @O_SQL_Error_State int = NULL output as declare @cSelectList varchar(255)<c/> @cSubquery1 varchar(255)<c/> @cSubquery2 varchar(255)<c/> @cSubquery3 varchar(255)<c/> @cSubquery4 var<nl/>2007-02-05 07:33:54.748 Category:NULL<nl/>Source: Microsoft SQL Native Client<nl/>Number: 213<nl/>Message: Insert Error: Column name or number of supplied values does not match table
I am beginning to wonder how many others I will encounter, both fail at the errors.
Has anyone successfully accomplish this?
We currently have two SQL Server 2005 Servers. We would like to replicate the dynamics and our data to the other server. Currently the only way I can accomplish this is by
snapshot replication (as not all tables have primary keys).
It keeps failing though, I am getting the following errors:
Agent message code 213. Insert Error: Column name or number of supplied values does not match table definition.<nl/>2007-02-04 07:00:38.401 Category:COMMAND<nl/>Source: Failed Command<nl/>Number: <nl/>Message: create procedure "dbo"."AddGPSSQLErrorCode" @cName char(30)<c/> @cText char(255) as declare @iCode int begin transaction select @iCode = max(CODE) + 1 from GPS_SQL_Error_Codes with (UPDLOCK) insert into GPS_SQL_Error_Codes values ( 0<c/> @iCode<c/> @cName<c/> @cText) select @iCode commit transaction <nl/><nl/>2007-02-04 07:00:38.416 Category:NULL<nl/>Source: Microsoft SQL Native Client<nl/>Number: 213<nl/>Message: Insert Error: Column name or number of supplied values does not match table
'glChangeDistAcca44d185_882.sch'<nl/>2007-02-05 07:33:54.638 Agent message code 213. Insert Error: Column name or number of supplied values does not match table definition.<nl/>2007-02-05 07:33:54.732 Category:COMMAND<nl/>Source: Failed Command<nl/>Number: <nl/>Message: create procedure "dbo"."glCLAccountMSTR" @I_cUser_ID char(15) = NULL<c/> @I_tMCRegistered tinyint = NULL<c/> @I_cReporting_Currency char(15) = NULL<c/> @I_cAccount_MSTR_Table_Name char(255) = NULL<c/> @I_cFixed_Alloc_Table_Name char(255) = NULL<c/> @I_cSeg_Desc_Table_Name char(255) = NULL<c/> @I_cSeg_Desc_Temp_Table char(30) = NULL<c/> @O_SQL_Error_State int = NULL output as declare @cSelectList varchar(255)<c/> @cSubquery1 varchar(255)<c/> @cSubquery2 varchar(255)<c/> @cSubquery3 varchar(255)<c/> @cSubquery4 var<nl/>2007-02-05 07:33:54.748 Category:NULL<nl/>Source: Microsoft SQL Native Client<nl/>Number: 213<nl/>Message: Insert Error: Column name or number of supplied values does not match table
I am beginning to wonder how many others I will encounter, both fail at the errors.
Has anyone successfully accomplish this?