slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Administration Forums - Synchronization
Forum to discuss SalesLogix synchronization and remote database management. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Synchronization | New Thread

View: Search:

Author

Thread: Triggers and Set Nocount on

Lane
Posts: 121

Triggers and Set Nocount on Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 10 May 07 10:47 AM

In prior versions having triggers on the database without "set nocount on" would cause sync server errors and transaction rollback issues. Under 6.2.6 I now see SLX triggers with out this setting. Does anyone know if syncserver was updated to handle this case properly or are there still issues or settings we need to be using in triggers to allow standard sync processing to operate independent from integration or customizations processes

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: Triggers and Set Nocount on Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 11 May 07 10:54 PM

Quote:

Originally posted by Lane

... Under 6.2.6 I now see SLX triggers with out this setting. ...

What triggers? Are you talking about ExchangeLink triggers? They do not sync.
--
rjl

[Reply][Quote]

Lane
Posts: 121

Re: Triggers and Set Nocount on Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 13 May 07 7:11 AM

Triggers are tied to the SLXRECCHANGE table

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: Triggers and Set Nocount on Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 19 May 07 11:01 AM

All part of ExchangeLink.

FYI - Work has started on an update to ExchangeLink. AFAIK the plan is to get rid of SQL Triggers and go with "SLX_TRiggers" - a "special feature in SalesLogix that is reserved for SalesLogix only (it is NOT getting exposed to the "community - too messy). This will enable ExchangeLink to be used w/Oracle based SalesLogix systems (cannot right now).

As far as a date is concerned.. all I know is "sometime" before the end of the current Sage year (ends Oct 1).. but don't quote me on that.
--
rjl

--
rjl

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/25/2024 4:39:20 PM