<div>
Hey JimFive. Thanks for your response.<br />
<br />
<br />
I have replace all &quot;GO&quot; Statement with &quot;;&quot;. but Still i am getting the Same Error.
</div>


Hey JimFive. Thanks for your response.


I have replace all "GO" Statement with ";". but Still i am getting the Same Error.

<div>
What is the actual value of ScriptText?
</div>


<div>
Partial Solution. didn't really work in our case
</div>


Partial Solution. didn't really work in our case

<div>
<div class="content wysiwyg-content">
Hello Friends,<br />
<br />
I have SQL Script File for Creating Whole database.<br />
<br />
I want to execute that &quot;Script&quot; file from my c# application.So I used SMO Object for it. But some how it is giving me error that &quot;could not connect to the server&quot;. <br />
<br />
I have also tried SqlHelper.ExecuteNonQuery(<wbr />ScriptText<wbr />). but throws error that <br />
&quot;Incorrect Systax near GO Statement&quot;<br />
<br />
<b>Note</b> that this same query is WORKING fine while executing direct from SQL SERVER. So, <b>No Errors in Script File</b>.<br />
<br />
I am using SQL SERVER 2008 R2. <br />
<br />
I also want to know the same logic will work in SQL SERVER 2005 ?<br />
<br />
Please feel free to ask in case of any query<br />
<br />
Thanks In Advance.
</div>
</div>


Hello Friends,

I have SQL Script File for Creating Whole database.

I want to execute that "Script" file from my c# application.So I used SMO Object for it. But some how it is giving me error that "could not connect to the server". 

I have also tried SqlHelper.ExecuteNonQuery(ScriptText). but throws error that 
"Incorrect Systax near GO Statement"

Note that this same query is WORKING fine while executing direct from SQL SERVER. So, No Errors in Script File.

I am using SQL SERVER 2008 R2. 

I also want to know the same logic will work in SQL SERVER 2005 ?

Please feel free to ask in case of any query

Thanks In Advance.

SMO Error - Cannot Connect to Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Kernel and system programming is the process of creating the software necessary for a computer or device to function and operate other programs. Some operating systems (such as Microsoft Windows) are proprietary, but others, such as the various Linux distributions, are open source.