Page 1 of 1

MS SQL Server - Script length

Posted: Sun Aug 03, 2014 7:18 pm
by AdrianGray
Is there a limit to the number of lines you can load into the script area. Our current script is around 43,000 lines which is throwing an error. I can copy and paste the script from notepad, however the "Load Script" button does not import it. Once inserted, when I build and run the project, I get a "Unable to load plug-in library. Please rebuild your project..." error message even though the same call with a smaller script ran successfully just prior. Thanks, Adrian.

PS Is there a way I can get InstallAware to launch a script (passing the login parameters) without having to paste it in the script area. This installer will be run in several environments, with the SQL Authentication details being read from a config file in each case.

Re: MS SQL Server - Script length

Posted: Mon Aug 04, 2014 9:29 am
by FrancescoT
Dear Adrian,

I suggest you to use the "sqlcmd Utility" in such cases.
You run a call to SQLCMD using Run Program command.

http://technet.microsoft.com/en-us/library/ms165702(v=sql.105).aspx

Hope this helps you.

Regards

Re: MS SQL Server - Script length

Posted: Thu Aug 07, 2014 3:42 am
by AdrianGray
Thanks, working well now.

Re: MS SQL Server - Script length

Posted: Thu Aug 07, 2014 4:47 am
by FrancescoT
:D