SQL Errorrrrrrr!!

suvidhab_s

Hi,

We are using NAV 2009 SP1 with SQL Server 2008 R2.

While Trying to post a Consumption Entry, We are facing the below shown error..



PLZ HELP

ara3n

i suggest to install sp1 for sql 2008 r2

suvidhab_s

Thanks for the suggestion... But It did not help :? :roll:
Anything else??

Egnaz

Have you restarted the sql server?
Are you using any stored procedures in this process on the sql server?

Regards,
egnaz

suvidhab_s

Yes I restarted SQL Server and It dint help either.
This process is not using any stored procedure.

Error comes when i try to post a Consumption entry from Navison!!

Egnaz

Hi suvidhab_s,

after a little bit more of research I found and interesting link for you: http://connect.microsoft.com/SQLServer/ ... e-1-line-1
Looks like a sql error with database names with non latin characters. Maybe this could help you to locate the problem.

Keep me up to date please.

Regards,
egnaz

suvidhab_s

Hii...

Thank you for your suggestions.

I Re-Indexed the tables in connection with the process and It worked \:D/

Egnaz

You're welcome.
Thank you for telling us your solution.