Forum

Hi Aderson,

I just wanted to let you know that I removed the 'Go' command as you suggested and the script is now working when I install the module.

I couldn't find any information as to why the script would work differently in DNN, so it looks like I will have to write something to generate the script. I don't want to have to remove all those 'Go' statements by hand again :-)

Thank you once again for your help.

Best Regards,

Steve

Hi Aderson,

According to https://stackoverflow.com/questions/2299249/what-is-the-use-of-go-in-sql-server-management-studio-transact-sql"
"The GO command isn't a Transact-SQL statement, but a special command recognized by several MS utilities including SQL Server Management Studio code editor."

So I guess it can be removed completely. I'm not sure how DNN runs SQL but presumably, it doesn't recognise the Go command.

But that still leaves me with generated scripts that don't work. I could write something to remove them I suppose being careful not to remove the letters 'go' from anywhere else in the script. Or I could write my own script generator as mentioned, there are some other things i would like to include like checking if a record already exists before attempting to insert it, that would make my scripts re-runnable.

Steve