DotNetInvoice Forums

I know I can go through and change all the sql to have the 'with' qualifier. 

 Would it be possible to get the scripts provided by DNI to start using 'with' on the (nolock) table hints?  The main reason being that SQL Azure doesn't not support statements without the with.  And it would be nice if the scripts provided had the with in there so there was no manual editing to the upgrade scripts.

 Here is the message:

"Deprecated feature 'Table hint without WITH' is not supported in this version of SQL Server"

Scott,

We've put this issue in our tracking system to look into Azure compatibility with our next release.  If you run into anything else that causes problems other than the WITH statements, please let us know.