# Navision Database restore in SQL Server 2005- facing issue with stored procedure **URL:** \ **Category:** Technical Forum\ **Created:** [August 6, 2008, 10:02am UTC](https://www.dynamicsuser.net/t/navision-database-restore-in-sql-server-2005-facing-issue-with-stored-procedure/19713 "2008-08-06T10:02:46Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![nvasuki](https://avatars.discourse-cdn.com/v4/letter/n/ad7895/32.png) [@nvasuki](https://www.dynamicsuser.net/u/nvasuki)\ **Post date:** [August 6, 2008, 10:02am UTC](https://www.dynamicsuser.net/t/navision-database-restore-in-sql-server-2005-facing-issue-with-stored-procedure/19713/1 "2008-08-06T10:02:46Z")
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 ---
**Author:** ![Legosz](https://avatars.discourse-cdn.com/v4/letter/l/ed655f/32.png) [@Legosz](https://www.dynamicsuser.net/u/Legosz)\ **Post date:** [August 6, 2008, 5:54pm UTC](https://www.dynamicsuser.net/t/navision-database-restore-in-sql-server-2005-facing-issue-with-stored-procedure/19713/2 "2008-08-06T17:54:06Z")
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. ---
**Author:** ![DenSter](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/denster/32/7478_2.png) [@DenSter](https://www.dynamicsuser.net/u/DenSter)\ **Post date:** [August 7, 2008, 2:59pm UTC](https://www.dynamicsuser.net/t/navision-database-restore-in-sql-server-2005-facing-issue-with-stored-procedure/19713/3 "2008-08-07T14:59:17Z")
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. ---
**Author:** ![nvasuki](https://avatars.discourse-cdn.com/v4/letter/n/ad7895/32.png) [@nvasuki](https://www.dynamicsuser.net/u/nvasuki)\ **Post date:** [August 9, 2008, 6:47am UTC](https://www.dynamicsuser.net/t/navision-database-restore-in-sql-server-2005-facing-issue-with-stored-procedure/19713/4 "2008-08-09T06:47:37Z")
Thanks. Yes its due to SQL Perform license. I have got the scripts and executed its working fine