in

Dynamics User Group

Since 1995 - The Microsoft Dynamics Online User Community
Dynamics User Group » Microsoft Dynamics NAV / Navision » NAV / Navision - Microsoft SQL Server » Navision Database restore in SQL Server 2005- facing issue with stored procedure

Navision Database restore in SQL Server 2005- facing issue with stored procedure

Last post 08-09-2008 7:47 by nvasuki. 3 replies.
Page 1 of 1 (4 items)
Write a New Post Sort Posts: Previous Next

  • 08-06-2008 11:02

    • nvasuki
    • Not Ranked
    • Joined on 08-06-2008
    • Posts 3
    • Points 60

    Navision Database restore in SQL Server 2005- facing issue with stored procedure

    Reply Contact

    We are using Navision 4.0(SP3). I am new to Navision and Database Administartion. I got restored the Navision production database backup (SQL Server 2005) in to our testing environment. Everything works fine from when I setup the application from the restored database but I am not able to execute any of the stored procedures in the SQL Management studio.It gives me the following error

    'Msg 102, Level 15, State 1, Procedure pt_help, Line 1
    Incorrect syntax near '?'.'
     please advise me
    • Post Points: 35

  • 08-06-2008 18:54 In reply to

    • Legosz
    • Top 500 Contributor
      Male
    • Joined on 02-19-2008
    • Toronto, ON
    • Posts 58
    • Points 930

    Re: Navision Database restore in SQL Server 2005- facing issue with stored procedure

    Reply Contact

    Firstly, check the code you are calling your SP with.Secondly, check your SP for the '?' character. Feel free to paste the code you're using to call your SP.

    • Post Points: 5

  • 08-07-2008 15:59 In reply to

    • DenSter
    • Top 10 Contributor
      Male
    • Joined on 01-23-2004
    • Howell, MI
    • Posts 1,318
    • Points 17,805
    • DynamicsNAVMVP

    Re: Navision Database restore in SQL Server 2005- facing issue with stored procedure

    Reply Contact

    From the name of that stored procedure it looks like you have SQL Perform installed on your production database. You need a license to be able to run that stored procedure on other servers, and you need to have certain things installed before you can run them. Get in touch with whoever is in charge of the production database, and let them tell you how it works. Any stored procedure that starts with pt_ is not going to work until you have a license for it.

    Daniel Rimmelzwaan
    RIS Plus LLC
    Microsoft Dynamics NAV - MVP
    • Post Points: 20

  • 08-09-2008 7:47 In reply to

    • nvasuki
    • Not Ranked
    • Joined on 08-06-2008
    • Posts 3
    • Points 60

    Re: Navision Database restore in SQL Server 2005- facing issue with stored procedure

    Reply Contact

    Thanks. Yes its due to SQL Perform license. I have got the scripts and executed its working fine
    • Post Points: 5
Page 1 of 1 (4 items)

Copyright Dynamics User Group, 1995-2008, all rights reserved. This website and user group are independent and not affiliated with the Microsoft Corporation.