Forum


HomeHomePremiumPremiumDevelopmentDevelopmentDatabase installation script errorDatabase installation script error
Previous
 
Next
New Post
11/15/2017 8:52 AM
 

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

 
New Post
11/15/2017 10:37 AM
 

Happy that it worked Steve! BTW, I think it has to do with transaction and when you call "GO" you are closing a transaction. That doesn't explain why it works within Management Studio though, I know.

Cheers,

Aderson

 
New Post
11/15/2017 11:34 AM
 

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

 
Previous
 
Next
HomeHomePremiumPremiumDevelopmentDevelopmentDatabase installation script errorDatabase installation script error



Try FREE
30 days money back guaranteed