Finance | Project Operations, Human Resources, ...

Error opening Project in Project Analyzer

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello,

I created a test system and test company database based off of my live database. I am receiving an error in my test environment when I open a Project in Project Analyzer.

sql server message 8144

procedure or function PJPROJ_spk2 has too many arguments specified.

Using the Database Maintenance, I ran Execute views and Stored Procedures.

Any other things that I should check?

All responses (2)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Error opening Project in Project Analyzer

that worked! Thanks!!
Suggested answer

CFROTON 4,710 on at

Like (0)

Report

RE: Error opening Project in Project Analyzer

Dear Kenzie,

You can find that stored proc on your live db, right click it "Script Stored procedure as" and use Alter to, new query editor window. Then run it on your test. I'm assuming this works in Live.

Best Regards,

Jana MacDonald

MSFT Support