MS SQL Server - Script length

[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.

[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

[AdrianGray]

Thanks, working well now.

[FrancescoT]