I'm trying to upload the DotNetNuke database from my local PC to my ASP's server using DTS and I'm getting the following errors in the following stored procedures:

AddEvent
Invalid column name 'Description'.

DeleteEvent
Invalid column name 'ItemId'.

UpdateEvent
Invalid column name 'Description'
Invalid column name 'ItemId'.

GetEvent
Invalid column name 'CreatedByUser'
Invalid column name 'IconFile'
Invalid column name 'ItemId'
Invalid column name 'Description'
Invalid column name 'DateTime'
Invalid column name 'Title'
Invalid column name 'ExpireDate'
Invalid column name 'IconFile'
Invalid column name 'AltText'
Invalid column name 'ItemId'.

GetEvents
Invalid column name 'DateTime'
Invalid column name 'ExpireDate'
Invalid column name 'ExpireDate'.

GetEventsByDate
Invalid column name 'IconFile'
Invalid column name 'ItemId'
Invalid column name 'Description'
Invalid column name 'DateTime'
Invalid column name 'Title'
Invalid column name 'ExpireDate'
Invalid column name 'CreatedByUser'
Invalid column name 'IconFile'
Invalid column name 'AltText'
Invalid column name 'DateTime'
Invalid column name 'DateTime'
Invalid column name 'DateTime'.

Forum_ForumTrackingGet
Invalid column name 'LastForumsView'.




Anyone any ideas how I can sort these out?

The errors are due to the fact that the stored procedures created by DNN do not have [] around keywords that are used as identifiers. 

You have a few options.....

1.  You can look at modifying the stored procedures (NOTE: this might or might not break DNN I do not believe that it will, but I have not tested it)

2.  You can use a backup/restore process to move the database this will get around the issue

3.  If you are not using the modules that use the offending tables and procedures you could just remove them (NOT RECOMMENDED but can be done)

---

-Mitchel Sellers
Microsoft MVP, ASPInsider, DNN MVP
CEO/Director of Development - IowaComputerGurus Inc.


Visit mitchelsellers.com for my mostly DNN Blog and support forum.

Visit IowaComputerGurus.com for free DNN Modules, DNN Performance Tips, DNN Consulting Quotes, and DNN Technical Support Services