Hi All

I have encountered a problem with migrating a DNN to an SQL Serve 2005 platform from a SQLServer 2000 platform that somebody might be able to help me with. The problem has manifested within the stored procedures used by the Forum module but I am sure it exists elsewhere. Basically where there is an ''EXEC {object_qualifer}procedurename statement within the procedure, it seems the database now expects the schema name to be prefixed also. Therefore in the forum stored procedure [dbowner].[dnn_Forum_StatisticsGet] procedure there is a statement    

BEGIN
        EXEC dnn_Forum_AA_StatisticsSiteUpdate 0, 0, @ModuleID, @TabId       
END

It seems in SQL Server 2005, the DB engine expects this to be prefixed by the schema name (unles this can be configured otherwise?) At runtime this causes an error unless the schema name is included. Has anyone come across any strategies for dealing with this or am I basically hosed on 2005?

 

Rgds Colm

---

Colm Ryan Director
3rd i IT and Business Services Limited

www.actravia.com
Registration and Booking Solutions for Dotnetnuke
www.3rdi.ie
IMCA Registered Management Consulting Practice. Business and IT Strategy, IT Project Management and Product Development