Altering database of sql 2005 from navision

abhi_kadu
abhi_kadu Member Posts: 8
edited 2007-06-02 in SQL General
I am getting an error while altering the sql 2005 database from navision.
Abhijit Kadulkar
(Project Leader)
Direction Software Solutions

Comments

  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    What error?? :?
    Marije Brummel | Freelance Business Central Specialist
  • Waldo
    Waldo Member Posts: 3,412
    Is your user system administrator / dbowner?

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • abhi_kadu
    abhi_kadu Member Posts: 8
    edited 2006-12-08
    I am getting an error while altering the sql 2005 database

    'You can not enter '2147483648 KB. The cursor is in front of invalid character'

    user is 'sa' which is a dbowner
    Abhijit Kadulkar
    (Project Leader)
    Direction Software Solutions
  • Waldo
    Waldo Member Posts: 3,412
    And what are you altering into what?

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • jth
    jth Member Posts: 16
    'You can not enter '2147483648 KB. The cursor is in front of invalid character'

    Hi!
    I guess you are using Nav4.

    You need to get a patch vor Navision or you have to use a newer version like SP1 or SP2.
    The patch number is 272944 and is available from MS.

    JTH
  • abhi_kadu
    abhi_kadu Member Posts: 8
    I can not go into the screen of alter database. when i click on alter database option i got an error.

    I am using Navision with SP2 .
    Abhijit Kadulkar
    (Project Leader)
    Direction Software Solutions
  • jth
    jth Member Posts: 16
    Ok. Just checked it. In my case it was also SP2.
    You need a HF for NAV 4 SP 2.
    Try the two available hotfixes for SP2.
    The build number which solved my problem was:

    4.0.2.22611

    Greetings
    J
  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from Upcoming version 5.0 (AKA Dynamics NAV) forum to Navision forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Waldo
    Waldo Member Posts: 3,412
    I guess there is an invalid value in the $ndo$dbproperty table in SQL Server. You can check (and alter) the values for each field.

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • kine
    kine Member Posts: 12,562
    1) See my blog, I described the problems with Altering database under MS SQL 2005.
    2) You need to have 4.00 SP2 + Update 1 - this is a minimum...
    3) If you fullfill point 2, you can open the Alter Database dialog, but still you need to enter correct size into the box. Do not forget, that Trans. Log under MS SQL 2005 has limited max. size. And do not forget, that the no. showed by default is in bytes, but the name of column is "Maximum size (MB)" - you need to enter the size in MB, not in bytes... 8) (there is difference between MS SQL 2000 and 2005, where NAV on SQL 2000 shows you correct value, but on SQL 2005 shows you size in B and not in MB...)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from Navision forum to SQL General forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories