Sorry, should have looked at your post closer. If you update the 500 to something bigger it should work. 5.0.3 work in a slightly different (but better) way, but is likely to reduce your sub-calendar limit to about 65, this will be upped to about 250 in version 5.0.4.

Cheers
Roger

Are you seeing the sproc in SQL Server Management Studio. If so, just change it and you should be done. If in one of the SQLDataProvider files that come with the install, I'll have to give you more guidance.

Not sure when 5.0.4 will be finally released. I can imagine that it will be at least a couple of months before it gets through the DNN release process.

Cheers
Roger

Hi Randy,

I'm guessing you don't have SSMS... If you take the code you see in 05.00.02.SqlDataProvider, copy the text starting from 'CREATE PROCEDURE {databaseOwner}{objectQualifier}EventsGetByRange' down to 'GO'. Then change the CREATE to ALTER and change the 500 to 1024. Then paste this into the box you see on the Host/SQL page, tick Run as Script and click Execute.

Cheers
Roger