The Author Online Book Forums are Moving

The Author Online Book Forums will soon redirect to Manning's liveBook and liveVideo. All book forum content will migrate to liveBook's discussion forum and all video forum content will migrate to liveVideo. Log in to liveBook or liveVideo with your Manning credentials to join the discussion!

Thank you for your engagement in the AoF over the years! We look forward to offering you a more enhanced forum experience.

Liston (4) [Avatar] Offline
#1
Hi - nice book! Thanks.

After running through the process you describe in "Setting up the source code" (starting on page xxx), I clicked the link to run the Sales By Territory report, and got:

An error has occurred during report processing.
Query execution failed for data set 'dsTerritory'.
Could not find stored procedure 'spGetTerritory'.

Turns out there's a T-SQL script, RS2005INActionDatabasesp.sql, which creates the stored procedures - thought I'd post this for folks like me who who read the directions.

Also noticed the database project RS2005INActionDatabaseDatabase.sln is in VS 2003, but the convert works just fine.

Thanks again for a wonderful book - Liston