# DBT SQLSERVER Index creation issue

**URL:** <https://discourse.getdbt.com/t/dbt-sqlserver-index-creation-issue/10906>\
**Category:** Help\
**Created:** [November 22, 2023, 1:48pm UTC](https://discourse.getdbt.com/t/dbt-sqlserver-index-creation-issue/10906 "2023-11-22T13:48:40Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sentamilselvan.k](https://avatars.discourse-cdn.com/v4/letter/s/f19dbf/32.png) [@sentamilselvan.k](https://discourse.getdbt.com/u/sentamilselvan.k)\
**Post date:** [November 22, 2023, 1:48pm UTC](https://discourse.getdbt.com/t/dbt-sqlserver-index-creation-issue/10906/1 "2023-11-22T13:48:41Z")

</div>

Completed with 1 error and 0 warnings:  
13:30:46  
13:30:46 (‘42000’, ‘[42000] [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]CREATE INDEX statement failed because a columnstore index cannot be created in this edition of SQL Server. See Books Online for more details on feature support in different SQL Server editions. (35315) (SQLMoreResults)’)

Facing the above error, which dbt -SQL Server model creation. Source table is have indexes. But, i’m not need the indexes. i have to create the table (Model) with out indexes.  
Any one provide the idea?

{{ config(materialized=‘table’) }}

with source\_data as (

```
select 1 as id
union all
select null as id

```

)

select \*  
from source\_data

---

<div class="post-metadata">

**Author:** ![katab](https://avatars.discourse-cdn.com/v4/letter/k/3ec8ea/32.png) [@katab](https://discourse.getdbt.com/u/katab)\
**Post date:** [December 14, 2023, 3:04pm UTC](https://discourse.getdbt.com/t/dbt-sqlserver-index-creation-issue/10906/2 "2023-12-14T15:04:35Z")

</div>

It’s a MSSQL specific issue, try to update your config settings:  
`{{ config({'materialized':'table', 'as_columnstore':false}) }}`  
Helped me to resolve the same issue.

You might find this documentation page useful:

> **[Microsoft SQL Server configurations | dbt Developer Hub](https://docs.getdbt.com/reference/resource-configs/mssql-configs)**
>
> Materializations