# GO statement been treated as a delimiter in single changeset file
**URL:** https://forum.liquibase.org/t/go-statement-been-treated-as-a-delimiter-in-single-changeset-file/4781
**Category:** General Discussion
**Created:** [November 2, 2020, 2:12pm UTC](https://forum.liquibase.org/t/go-statement-been-treated-as-a-delimiter-in-single-changeset-file/4781 "2020-11-02T14:12:44Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@virender.jain77](https://forum.liquibase.org/u/virender.jain77)
#### Post date: [November 2, 2020, 2:12pm UTC](https://forum.liquibase.org/t/go-statement-been-treated-as-a-delimiter-in-single-changeset-file/4781/1 "2020-11-02T14:12:45Z")
In my changeset file I have several SQL statements that end with GO statement, when I run the Liquibase update / deploy it fails with error
Unexpected error running Liquibase: Incorrect syntax near ‘GO’. [Failed SQL: (102)
Using Liquibase with SQL Server
---
### Author:  [@ronak](https://forum.liquibase.org/u/ronak)
#### Post date: [November 10, 2020, 9:29pm UTC](https://forum.liquibase.org/t/go-statement-been-treated-as-a-delimiter-in-single-changeset-file/4781/2 "2020-11-10T21:29:41Z")
Hi @virender.jain77!
Would you please share the following:
- The exact command line you are running for liquibase diff command?
- Share your liquibase.properties file (if you have any, please take out the passwords)
- exact error output (please make sure to set logLevel=debug).
Thanks,
Ronak
---
### Author:  [@virender.jain77](https://forum.liquibase.org/u/virender.jain77)
#### Post date: [November 11, 2020, 12:28pm UTC](https://forum.liquibase.org/t/go-statement-been-treated-as-a-delimiter-in-single-changeset-file/4781/3 "2020-11-11T12:28:01Z")
Script File
–liquibase formatted sql
–changeset XXXX:2 context:XXXX endDelimiter:` runOnchange:true splitStatements=false
SET ANSI\_NULLS ON
GO
SET QUOTED\_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Region](
[RegionID] [int] NOT NULL,
[RegionDescription] nchar NOT NULL)
GO
CREATE TABLE [dbo].[Emp](
[EmpID] [int] NOT NULL,
[Empname] nchar NOT NULL)
Properties file
liquibase --driver=“com.microsoft.sqlserver.jdbc.SQLServerDriver” --classpath="//opt//sqljdbc\_8.4//enu//mssql-jdbc-8.4.1.jre8.jar" --url=“jdbc:sqlserver://$servername:portremoved;databaseName=$databaseName;integratedSecurity=false;” --changeLogFile="$sql\_script" --username=login --password=\_pwd --contexts=$ChangeNumber update
---
### Author:  [@virender.jain77](https://forum.liquibase.org/u/virender.jain77)
#### Post date: [November 11, 2020, 12:32pm UTC](https://forum.liquibase.org/t/go-statement-been-treated-as-a-delimiter-in-single-changeset-file/4781/4 "2020-11-11T12:32:02Z")
I have multiple files and only cases where using GO is creating error if I remove GO statement and define next script in same file as separate changeset then no error reported.
Also how to use below statements if needed it fails due to GO and replacing with a new changeset is really not acceptable from developers perspective.
```auto
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
```
---
### Author:  [@virender.jain77](https://forum.liquibase.org/u/virender.jain77)
#### Post date: [November 23, 2020, 1:04pm UTC](https://forum.liquibase.org/t/go-statement-been-treated-as-a-delimiter-in-single-changeset-file/4781/5 "2020-11-23T13:04:17Z")
> [@virender.jain77](#):
>
> endDelimiter:`
This can be marked as closed.
I tried with endDelimiter:GO and it worked as expected when used fresh scripts. Looks during multiple tries this was earlier not working with endDelimiter:GO as well. So all good now. Thanks Ronak for your help.
---
### Author:  [@ritesh](https://forum.liquibase.org/u/ritesh)
#### Post date: [January 31, 2023, 12:33pm UTC](https://forum.liquibase.org/t/go-statement-been-treated-as-a-delimiter-in-single-changeset-file/4781/6 "2023-01-31T12:33:27Z")
Hi @virender.jain77
What was the issue?
I am also facing the same issue in Liquibase 4.17.2 version, it is working in Liquibase 4.12 version