Hi to everyone,

I am building my first module, everything seems to be working fine, i just created my Module Package. The problem comes when i try to install my module, to be specific, when DotNetNuke executes the SQL statements contained in my 01.00.00.SqlDataProvider.

It creates the tables and some StoredProcedures, but there is one StoredProcedure that causes a lot of errors, i tried to create it directly in the SQL Management Studio and it worked, i also tried using the HOST -> SQL tool in my web page, and it worked, 

So i have no idea what is the problem, hope someone can help me with this, i'm using DotNetNuke 4.5.5.

Thanks all of you for your time.

P.S. Here is a link to a zip file that contains my DataProvider and an image of the error.

SQLData Provider and Error Snapshot

Thanks for your answer Chris, but seems after adding a line  break at the end was not enough, I'm still getting a lot of errors, I already had the GO statement at the end of the StoreProcedure.

This storeprocedure its the last part of the file.

Thanks again, and hope you have more ideas :D.

Sure Crhis, 

Here's the link,

SQLDataProvider ZIP File

I just read a post that says something about the + symbols (for concat), and that i shoud save my file in UTF-8 format for this, i'll try and i'll let you know.