Error when perform an update on Immediate Updating Subscriber

I have transaction replication setup between two servers running SQL Server
2000 (standard edition). The subscriber is an immediate updating subscriber.
I am having an issue when I try to update two tables from the subscriber.
When I attempt to perform an update on either table, I receive an error like
the following:
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near ')'.
Server: Msg 137, Level 15, State 1, Line 5
Must declare the variable '@.c120o'.
I looked at the syntax of the trg_MSsync_upd_<tablename> trigger and cannot
see any problem with the trigger's syntax.
Any help anyone can provide would be greatly appreciated.
Michael Conway
Calltower, Inc.
Database Administrator
Can you post the name and schema of your problem article?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"mconway" <mconway@.calltower.com.(donotspam)> wrote in message
news:33FA51A4-1FE7-494F-B992-20C644B3F0E2@.microsoft.com...
>I have transaction replication setup between two servers running SQL Server
> 2000 (standard edition). The subscriber is an immediate updating
> subscriber.
>
> I am having an issue when I try to update two tables from the subscriber.
> When I attempt to perform an update on either table, I receive an error
> like
> the following:
> Server: Msg 170, Level 15, State 1, Line 2
> Line 2: Incorrect syntax near ')'.
> Server: Msg 137, Level 15, State 1, Line 5
> Must declare the variable '@.c120o'.
> I looked at the syntax of the trg_MSsync_upd_<tablename> trigger and
> cannot
> see any problem with the trigger's syntax.
> Any help anyone can provide would be greatly appreciated.
>
> --
> Michael Conway
> Calltower, Inc.
> Database Administrator
|||I am having the issue with two articles so I am going to post the schema for
both tables. I am posting the schema as it is in production. There are
spaces in some of the column names, and at first I thought that this was the
cause of the problem, however I removed the spaces in the column names and
still received the same error.
CREATE TABLE [dbo].[Accounts] (
[ID] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[FName] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[LName] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[SSN] [nvarchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Phone] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Phone2] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Phone3] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Street] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[City] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[State] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Zip] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Email] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Status] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Grid] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Install Start Time] [int] NULL ,
[Install Duration] [int] NULL ,
[Sale Date] [smalldatetime] NULL ,
[Install Date] [smalldatetime] NULL ,
[Charge Back] [smalldatetime] NULL ,
[Who Entered] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[timeentered] [smalldatetime] NULL ,
[Lead Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Rep Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Tech Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Lead ID] [int] NULL ,
[Rep ID] [int] NULL ,
[Technician ID] [int] NULL ,
[Leadpaid] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Reppaid] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Techpaid] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Lead pay] [float] NULL ,
[Lead holdback] [float] NULL ,
[Lead bonus] [float] NULL ,
[Rep pay] [float] NULL ,
[Rep holdback] [float] NULL ,
[Rep bonus] [float] NULL ,
[Tech pay] [float] NULL ,
[Tech holdback] [float] NULL ,
[Tech bonus] [float] NULL ,
[AreaID] [int] NULL ,
[CC Number] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Promotion] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Promotion ID] [int] NULL ,
[Kit ID] [int] NULL ,
[Shipping Vendor] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Tracking Number] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Certificate Number] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[Virtual Certificate] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[Wiring] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Channels] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Structure] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Story] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Roof] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Cable] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Home Type] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Ala Carte] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[General] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Local] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Payment Type] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Receivers] [tinyint] NULL ,
[Payment] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Account Number] [nvarchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[R001] [nvarchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[R002] [nvarchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[R003] [nvarchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[R004] [nvarchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Claim ID] [nvarchar] (11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Owe] [float] NULL ,
[Tax] [float] NULL ,
[Collected] [float] NULL ,
[Autodebit] [tinyint] NULL ,
[Processed] [tinyint] NULL ,
[Submitted] [tinyint] NULL ,
[Paid] [tinyint] NULL ,
[Follow Up] [tinyint] NULL ,
[Processed Date] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Submitted Date] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Paid Date] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[collections] [tinyint] NULL ,
[campaignid] [int] NULL ,
[satelliteprovider] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[basepackageid] [int] NULL ,
[programmingquote] [float] NULL ,
[dishlocals] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[directlocals] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[numbertvs] [int] NULL ,
[subscriberid] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[contactdate] [datetime] NULL ,
[progreceivers] [int] NULL ,
[progprovider] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[progpackage] [int] NULL ,
[progpromotionid] [int] NULL ,
[confirminstallation] [tinyint] NULL ,
[arrival] [datetime] NULL ,
[departure] [datetime] NULL ,
[arrivalcode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[departurecode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[R005] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[R006] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Promo Code] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[confirminstalldate] [datetime] NULL ,
[received] [tinyint] NULL ,
[receiveddate] [datetime] NULL ,
[cancelled] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Fullfillment] [tinyint] NULL ,
[UpgradeID] [int] NULL ,
[leadreceivers] [float] NULL ,
[repreceivers] [float] NULL ,
[techreceivers] [float] NULL ,
[techmaterials] [float] NULL ,
[leadequipment] [float] NULL ,
[repequipment] [float] NULL ,
[techequipment] [float] NULL ,
[chargebackpaid] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[claimupdated] [float] NULL ,
[claimupdateddate] [datetime] NULL ,
[ScheduleSlotID] [bigint] NULL ,
[Warranty] [tinyint] NULL ,
[PreviousProvider] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Gender] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Employer] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[DOB] [datetime] NULL ,
[ReferralID] [bigint] NULL ,
[ReferralName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Installed] [tinyint] NULL ,
[OldKitID] [bigint] NULL ,
[OldPromotionID] [bigint] NULL ,
[ClaimID2] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[OldUpgradeID] [bigint] NULL ,
[BoundType] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[street2] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[UpgradeOptions] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[DriversLicense] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[DLState] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ChargebackReason] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ConvertDate] [datetime] NULL ,
[ConverTempID] [bigint] NULL ,
[LastUpdate] [datetime] NULL ,
[LastUpdateEmpID] [bigint] NULL ,
[msrepl_tran_version] [uniqueidentifier] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Employee] (
[ID] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[FName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[LName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Phone] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Phone2] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Phone3] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Inactive] [smallint] NULL ,
[Lead Plan] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Rep Plan] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Tech Plan] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[user] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[password] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[expiration date] [smalldatetime] NULL ,
[street] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[city] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[zip] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[state] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ssn] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[email] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Type] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Lead Rep] [tinyint] NULL ,
[Rep] [tinyint] NULL ,
[Tech] [tinyint] NULL ,
[links] [tinyint] NULL ,
[add] [tinyint] NULL ,
[update] [tinyint] NULL ,
[delete] [tinyint] NULL ,
[lookup] [tinyint] NULL ,
[scheduler] [tinyint] NULL ,
[accounts] [tinyint] NULL ,
[openticket] [tinyint] NULL ,
[openbilling] [tinyint] NULL ,
[leadcenter] [tinyint] NULL ,
[creditcard] [tinyint] NULL ,
[employee] [tinyint] NULL ,
[areas] [tinyint] NULL ,
[promotions] [tinyint] NULL ,
[promocodes] [tinyint] NULL ,
[makekits] [tinyint] NULL ,
[equipment] [tinyint] NULL ,
[payplans] [tinyint] NULL ,
[preferences] [tinyint] NULL ,
[commissions] [tinyint] NULL ,
[admin] [tinyint] NULL ,
[reports] [tinyint] NULL ,
[receivers] [tinyint] NULL ,
[export] [tinyint] NULL ,
[payments] [tinyint] NULL ,
[production] [tinyint] NULL ,
[route] [tinyint] NULL ,
[statistics] [tinyint] NULL ,
[status] [tinyint] NULL ,
[leadaccounts] [tinyint] NULL ,
[leadpayroll] [tinyint] NULL ,
[repaccounts] [tinyint] NULL ,
[reppayroll] [tinyint] NULL ,
[techpayroll] [tinyint] NULL ,
[techaccounts] [tinyint] NULL ,
[top] [tinyint] NULL ,
[installed] [tinyint] NULL ,
[pending] [tinyint] NULL ,
[cancelled] [tinyint] NULL ,
[chargeback] [tinyint] NULL ,
[reconciliation] [tinyint] NULL ,
[accounting] [tinyint] NULL ,
[receiveables] [tinyint] NULL ,
[reserviced] [tinyint] NULL ,
[rescheduled] [tinyint] NULL ,
[notscheduled] [tinyint] NULL ,
[channels] [tinyint] NULL ,
[churn] [tinyint] NULL ,
[r00] [tinyint] NULL ,
[missing payments] [tinyint] NULL ,
[deactivations] [tinyint] NULL ,
[disconnects] [tinyint] NULL ,
[salestax] [tinyint] NULL ,
[residuals] [tinyint] NULL ,
[exceptions] [tinyint] NULL ,
[servicecalls] [tinyint] NULL ,
[ra] [tinyint] NULL ,
[individualstatistics] [tinyint] NULL ,
[allstatus] [tinyint] NULL ,
[process] [tinyint] NULL ,
[campaigns] [tinyint] NULL ,
[adcampaignreport] [tinyint] NULL ,
[equipmentsalesreport] [tinyint] NULL ,
[missingcertsreport] [tinyint] NULL ,
[undepositedfunds] [tinyint] NULL ,
[Inventory] [tinyint] NULL ,
[TechArriveDepart] [tinyint] NULL ,
[TechInventoryReport] [tinyint] NULL ,
[btnR00] [tinyint] NULL ,
[btnNotes] [tinyint] NULL ,
[btnInvoices] [tinyint] NULL ,
[btnProgramming] [tinyint] NULL ,
[btnReceivables] [tinyint] NULL ,
[btnCreditCard] [tinyint] NULL ,
[btnBankInfo] [tinyint] NULL ,
[btnBilling] [tinyint] NULL ,
[btnContract] [tinyint] NULL ,
[btnService] [tinyint] NULL ,
[btnQuote] [tinyint] NULL ,
[quickbooks] [tinyint] NULL ,
[dataexport] [tinyint] NULL ,
[dataimport] [tinyint] NULL ,
[fake1] [tinyint] NULL ,
[fake2] [tinyint] NULL ,
[fake3] [tinyint] NULL ,
[fake4] [tinyint] NULL ,
[hours] [tinyint] NULL ,
[payrolladministrator] [tinyint] NULL ,
[servicepay] [float] NULL ,
[timeoff] [tinyint] NULL ,
[installation] [tinyint] NULL ,
[negativecommissions] [tinyint] NULL ,
[collections] [tinyint] NULL ,
[WarrantySalesReport] [tinyint] NULL ,
[EmployeeSalesReport] [tinyint] NULL ,
[CommissionsReport] [tinyint] NULL ,
[UserType] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[TextMessage] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[btnCreditCardView] [tinyint] NULL ,
[btnMoveToLead] [tinyint] NULL ,
[btnManualSchedule] [tinyint] NULL ,
[CancelledReasonReport] [tinyint] NULL ,
[ReferralsReport] [tinyint] NULL ,
[callbacknotes] [tinyint] NULL ,
[toptechs] [tinyint] NULL ,
[LeadLedger] [tinyint] NULL ,
[RepLedger] [tinyint] NULL ,
[TechLedger] [tinyint] NULL ,
[Forecasting] [tinyint] NULL ,
[UserLogin] [tinyint] NULL ,
[POs] [tinyint] NULL ,
[AddEquipment] [tinyint] NULL ,
[EquipmentInventory] [tinyint] NULL ,
[AdjustInventory] [tinyint] NULL ,
[EquipmentLookup] [tinyint] NULL ,
[Aging] [tinyint] NULL ,
[DishCode] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[DirectCode] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[SalesByVendor] [tinyint] NULL ,
[InstalledReceivers] [tinyint] NULL ,
[TopOffice] [tinyint] NULL ,
[RepInvoices] [tinyint] NULL ,
[msrepl_tran_version] [uniqueidentifier] NOT NULL
) ON [PRIMARY]
"Hilary Cotter" wrote:

> Can you post the name and schema of your problem article?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> "mconway" <mconway@.calltower.com.(donotspam)> wrote in message
> news:33FA51A4-1FE7-494F-B992-20C644B3F0E2@.microsoft.com...
>
>
|||I tried unsubscribing to the publication. Then I removed any spaces in the
column names and changed any column names that were using reserved words.
Then I recreated the subscription and subscriber database. However, I still
received the same errors when I tried to update the two tables.
"Hilary Cotter" wrote:

> Can you post the name and schema of your problem article?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> "mconway" <mconway@.calltower.com.(donotspam)> wrote in message
> news:33FA51A4-1FE7-494F-B992-20C644B3F0E2@.microsoft.com...
>
>