What version of Sage 500 are you using?  Sage has an article in their knowledgebase with this occurring for version 7.4.  

Here is what the knowledgebase says about this issue and how to resolve.  It may help.

In this specific case, trying to register 7.40 version of Sage 500 ERP on SQL Server verson 2012 in preparation for upgrade to version 7.60. Found that issue related to syntax changes in update trigger for tsmsiteprofile.

In another instance of this error, it was a compatibility issue while trying to run the DB SYNC and registering while using a Sage 500 v7.40 database on a SQL Server v2012, which is not a supported configuration.

Replace the 7.40 version of the tsmsiteprofile update trigger with the 7.60 version of the trigger

Also, instead of running the DBSYNC utility on a SQL 2012 server, this process should be run on a SQL 2008 version.

We were using 7.4 and I did move the database from SQL 2008 to 2012. We are no longer using Sage but wanted to access for historical purposes. Is it possible to update the tsmsiteprofile and still use the 7.4v? We do not have the 7.6v.

Jamey
Check with your reseller if they have scripts or a utility to handle updates to Sage 500 triggers and stored procedures to replace the WITH APPEND and @ErrNo syntax - both of which were deprecated by Microsoft in SQL 2012. If not, RKL wrote a utility to handle this.

Thank you, but who is RKL?

Thank you, but who is RKL?

This is not an endorsement, but they are a large authorized Sage 500 ERP reseller.

Thank you

I should have mentioned it before, but Lou Davis is from a company called e2b Technologies, which is another fine Sage 500 ERP partner that I cannot officially endorse.