Got Seesion error while try to open the database

JAYESH
JAYESH Member Posts: 290
edited 2007-06-02 in SQL General
HI

I try to open the Navision database which is on server

I got error message


ERROR -

The following SQL server error(s) occured while accessing the session table
535."22003",[Microsoft][odbc sql server driver][sql server][different of two datatime columns caused overflow at runtime.

Can any one give me solution what i have to do with this error.

Thank you
JAYESH PATEL

Comments

  • ara3n
    ara3n Member Posts: 9,258
    there is somebody logged into the db for a very long time. Find that user from enterprise manager and kill that session.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • 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!

  • brijleo
    brijleo Member Posts: 70
    In Open database screen, in advance tab select the default in place of Named Pipe.

Categories