Problem in NAV SQL DB

Asiri
Asiri Member Posts: 26
edited 2011-01-19 in SQL General
Hi,

If we create new DB in NAV SQL option in version 3.7 and then we are unable to reopen the created DB again. Following error is displaying.
"The session table contains a MBSNavision field data type that is not compatible with SQL Server data type, Type : Integer,SQL Type : BIGINT"

Waiting for your early reply.

Thks
Asiri

Comments

  • 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!

  • bbrown
    bbrown Member Posts: 3,268
    What SQL version?
    There are no bugs - only undocumented features.
  • kine
    kine Member Posts: 12,562
    It seems that you are using 3.70 with MS SQL 2005 which is not supported...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • ASK_ITG
    ASK_ITG Member Posts: 30
    Hi.

    In the forum this has been posted:

    ****
    1. Start Management Studio and connect to your SQL Server.
    2. Expand Databases, expand the Navision Database, and expand Views.
    3. Right Click on the View dbo.Session and in the Drop Down Menu select
    Script view as --> Create to --> New Editor Window.
    4. Locate "THEN SP.[waittime]" and change the code to
    "THEN CAST(SP.[waittime] AS INT)" (without ")
    5. As the view already exists you have to change the CREATE VIEW
    command to ALTER VIEW.
    ****
    /Allan

Categories