Create New tables - getting error

palan
palan Member Posts: 26
edited 2010-07-05 in Navision Attain
Hi,

We have bought new navision tables from Microsoft and then imported the new licence file and tried creating new tables and getting the below error. Can you please advise on this error. Thanks.
Microsoft Navision Attain
The following SQL Server error(s) occurred:

4628,"01000",[Microsoft][ODBC SQL Server Driver][SQL Server]The ALL

permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the

entity.
OK

Comments

  • kriki
    kriki Member, Moderator Posts: 9,121
    Which versions of NAV and SQL are you using?
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • palan
    palan Member Posts: 26
    SQL 2008 & Navision 3.7
  • kriki
    kriki Member, Moderator Posts: 9,121
    Navision 3.7 objects or client (I think both).

    You need to upgrade your NAV client (=technical upgrade) to run well on SQL2008. You best upgrade to NAV2009SP1.

    No need to upgrade your objects.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • TonyH
    TonyH Member Posts: 223
    Unless is changed again... last I heard MS will no longer support a Technical Upgrade... just an FYI...

    t
  • David_Singleton
    David_Singleton Member Posts: 5,479
    They also don't support 3.70 so it doesn't really matter.
    David Singleton
  • TonyH
    TonyH Member Posts: 223
    David Singleton wrote:
    They also don't support 3.70 so it doesn't really matter.

    touché.... :wink:

Categories