Table import and creation problem on MSSQL2005

srle

Hello,

Recently, we have migrated Navision SQL Server database to a new server. Server has MSSQL Server 2005 installed, while on "old" server MSSQL Server 2003 was used. Since that moment, we have problem with importing and creating TABLE objects in that database.

The following error occurs: 4628, "01000", [Microsoft][ODBC SQL Server Driver][Sql Server]The ALL permission is depreceated and maintained only for compatibility. It DOES NOT imply ALL permisssions defined on the entity.

However, all other object types could be created and imported without problem.

If someone experienced similar problem or has some advice, I look forward for reply.

nunomaia

Are you using Navision 4.0 ?

Waldo

You are posting in the "Navision Attain" forum. So, you are nog running the 4.0 runtime?

If I remember correctly, for SQL2005, you should run 4.00 (preferrable SP3).[/b]

srle

No, I'm using Navision Attain 3.60. Is that a problem?

Waldo

I think it is.

Try to test it with a 4.00Sp3 runtime ... There won't be any problems.

Phenno

Waldo wrote:

I think it is.

Try to test it with a 4.00Sp3 runtime ... There won't be any problems.

MSSQL 2005 is not supported by <4.00SP2 versions... (or SP3?)

srle

Thank you all...

Waldo

No prob.
Can you put [solved] in the subject?

kriki

[Topic moved from Navision Attain forum to SQL General forum]