Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP10 to GP2010 Update ...
Microsoft Dynamics GP (Archived)

GP10 to GP2010 Update and syCompanyImages error

(0) ShareShare
ReportReport
Posted on by Bill Campbell

We are trying to update from GP10 to GP2010 - once the Utilities starts the update on the Dynamics Database.

CREATE TABLE [dbo].[syCompanyImages]( [RELID] [int] NOT NULL, [BinaryBlob] [varbinary](max) NOT NULL, CONSTRAINT [PK_syCompanyImages] PRIMARY KEY NONCLUSTERED  ( [RELID]  ) ON [PRIMARY], ) ON [PRIMARY]

- Click on OK - here is the second error

ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]Line 1: Incorrect syntax near 'max

There are a couple of notes in the system on the CompanyImages message but I do not find a solution to the problem.

*This post is locked for comments

  • Verified answer
    Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: GP10 to GP2010 Update and syCompanyImages error

    Hello Bill,

    Microsoft Dynamics GP 2010 is compatible with the following SQL versions/editions:

    --Microsoft SQL Server 2012 Enterprise, Standard or Express editions

    --Microsoft SQL Server 2008 R2 Enterprise, Standard or Express editions

    --Microsoft SQL Server 2008 Enterprise, Standard or Express editions with SP1 or later

    --Microsoft SQL Server 2005 Enterprise, Standard or Express editions with SP3 or later

    **11.00.1914 or higher is required to be compatible with SQL Server 2012

    What version of SQL are you currently running for Dynamics GP 10.00.1868?

    As mentioned, this error normally indicates that SQL 2000 is being used, which is not compatible or supported for Dynamics GP 2010 at all.

    Thanks,

  • Bill Campbell Profile Picture
    Bill Campbell on at
    RE: GP10 to GP2010 Update and syCompanyImages error

    I am in a SQL Server not compatible - I have an older SQL Server that has a ton of OLD apps databases and they are not prepared to update on the fly - so is SQL 2008 R2 the only solution?

    I am coming from GP10.00.1868 and trying to get to GP11.001259 (latest GP2010)

    Thanks

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: GP10 to GP2010 Update and syCompanyImages error

    Also, which version of GP 10 are you coming from and to which version of GP2010 are you going. If have had similar problems going from GP 10 SP5 to GP 2010. I went to GP 2010 RTM and then upgraded from there.

  • Suggested answer
    soma Profile Picture
    soma 24,408 on at
    RE: GP10 to GP2010 Update and syCompanyImages error

    Please find the below link to verify your meet the system requirements

    www.google.co.in/url

    Hope this helps!!!

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GP10 to GP2010 Update and syCompanyImages error

    Hi Bill,

    SQL Server Database Requirement for GP2010 is

    x86

    ï‚·

    Microsoft® SQL Server® 2008 R2 SP1 or later - Standard, Workgroup or Express Editions

    ï‚· Microsoft SQL Server 2008 SP1 or later - Standard, Workgroup or Express Editions

    ï‚· Microsoft SQL Server 2005 SP3 or later - Standard, Workgroup or Express Editions

    Supported Microsoft SQL Server Collation

    1. Dictionary Order Case Insensitive - Sort Order 52

    In the SQL Server Management Studio, right-click the SQL Server Name and click Properties: Server Collation = SQL_Latin1_General_CP1_CI_AS

    2. Binary - Sort Order 50

    In the SQL Server Management Studio, right-click the SQL Server Name and click Properties: Server Collation = Latin1_General_BIN

     

    And For x64

    ï‚·

    Microsoft SQL Server 2008 R2 SP1 or later - Standard, Workgroup or Express Editions

    ï‚· Microsoft SQL Server 2008 SP1 or later - Standard, Workgroup or Express Editions

    ï‚· Microsoft SQL Server 2005 SP3 or later - Standard, Workgroup or Express Editions

    Supported Microsoft SQL Server Collation

    1. Dictionary Order Case Insensitive - Sort Order 52

    In the SQL Server Management Studio, right-click the SQL Server Name and click Properties: Server Collation = SQL_Latin1_General_CP1_CI_AS

    2. Binary - Sort Order 50

    In the SQL Server Management Studio, right-click the SQL Server Name and click Properties: Server Collation = Latin1_General_BIN

     


    Please Verify if your SQL Server Meets the requirements.

    Regards,

    Santosh G

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans