error on altering database

laurentiu_irofte

when i choose to alter database i receive the following error:

"you cannot enter '10485760 kb' in integer. the cursor is in front of the invalid character"

enyone can help me?

THX

kriki

Probably the fields wants an integer (that says how many KB you want). So try to use just <10485760>.

laurentiu_irofte

in what i read about this problem i descover that is a bug in nav sp2 or something like that.. i try to set in sql de file growth at "unrestricted growth" and is a strange thing here.. i can setup all the files except logfile. the logfile remain at 2,097,152MB and navision don't suport files so big.
any ideas?

kine

You are using MS SQL 2005 and this version do not support "unrestricted" flag for Transaction logs anymore. You need to set some limit. Because the NAV 4.00SP2 has still some bugs regarding MS SQL 2005, you can get this error.

See my blog for more info about these problems of NAV with SQL 2005 in earlier versions (e.g. NAV 4.00SP2)