Altering database of sql 2005 from navision

abhi_kadu

I am getting an error while altering the sql 2005 database from navision.

Marije_Brummel

What error?? :?

Waldo

Is your user system administrator / dbowner?

abhi_kadu

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

Waldo

And what are you altering into what?

jth

'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

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 .

jth

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

[Topic moved from Upcoming version 5.0 (AKA Dynamics NAV) forum to Navision forum]

Waldo

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.

kine

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...)

kriki

[Topic moved from Navision forum to SQL General forum]