Create New tables - getting error

palanpalan 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

  • krikikriki Member, Moderator Posts: 9,112
    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!


  • palanpalan Member Posts: 26
    SQL 2008 & Navision 3.7
  • krikikriki Member, Moderator Posts: 9,112
    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!


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

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

    touché.... :wink:
Sign In or Register to comment.