# Code generated for a conditional index gives error in MS SQL Server

**URL:** https://forum.liquibase.org/t/code-generated-for-a-conditional-index-gives-error-in-ms-sql-server/4004
**Category:** Liquibase Development
**Created:** [May 27, 2019, 4:37pm UTC](https://forum.liquibase.org/t/code-generated-for-a-conditional-index-gives-error-in-ms-sql-server/4004 "2019-05-27T16:37:00Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![Sunil](https://avatars.discourse-cdn.com/v4/letter/s/5fc32e/32.png) [@Sunil](https://forum.liquibase.org/u/Sunil)
#### Post date: [May 27, 2019, 4:37pm UTC](https://forum.liquibase.org/t/code-generated-for-a-conditional-index-gives-error-in-ms-sql-server/4004/1 "2019-05-27T16:37:00Z")

</div>

Function call \<raise\_exception ( Liquibase update error:

-1: Unexpected error running Liquibase: Incorrect syntax near ‘(’. [Failed SQL: CREATE NONCLUSTERED INDEX XCR\_ACTIVE ON [dbo].CS\_PA\_VEH\_DELTA] ) \> failed, due to error \<50316\>: \<Liquibase update error:

-1: Unexpected error running Liquibase: Incorrect syntax near ‘(’. [Failed SQL: CREATE NONCLUSTERED INDEX XCR\_ACTIVE ON [dbo].CS\_PA\_VEH\_DELTA]\>.

```
I hope it’s not the first time this is happening to someone.
```