# T-SQL Project - Project now empty

**URL:** <https://community.sonarsource.com/t/t-sql-project-project-now-empty/8426>\
**Category:** SonarQube Cloud\
**Tags:** tsql, sonarqube-cloud\
**Created:** [April 3, 2019, 9:00am UTC](https://community.sonarsource.com/t/t-sql-project-project-now-empty/8426 "2019-04-03T09:00:47Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![pconnor](https://dub1.discourse-cdn.com/sonarsource/user_avatar/community.sonarsource.com/pconnor/32/984_2.png) [@pconnor](https://community.sonarsource.com/u/pconnor)\
**Post date:** [April 3, 2019, 9:00am UTC](https://community.sonarsource.com/t/t-sql-project-project-now-empty/8426/1 "2019-04-03T09:00:47Z")

</div>

All of a sudden one of our T-SQL projects is appearing empty. I have added verbose mode to the analysis and it seems it doesn’t associate the .sql files with any scanner:

```auto
09:41:56.986 DEBUG: 'RptSchedule\RptSchedule\dbo\Tables\Report_Schedule.sql' indexed with language 'null'
09:41:56.986 DEBUG: 'RptSchedule\RptSchedule\dbo\Tables\Schedule_Recipients.sql' indexed with language 'null'
09:41:56.986 DEBUG: 'RptSchedule\RptSchedule\dbo\Tables\Schedule_Report_List.sql' indexed with language 'null'
```

```auto
09:41:59.611 DEBUG: 'T-SQL Sensor' skipped because there is no related file in current project
```

We are using SonarCloud and run our analysis through the Azure DevOps pipelines.

Any help would be appreciated.

Thanks,  
Pete

---

<div class="post-metadata">

**Author:** ![Colin](https://dub1.discourse-cdn.com/sonarsource/user_avatar/community.sonarsource.com/colin/32/55255_2.png) [@Colin](https://community.sonarsource.com/u/Colin)\
**Post date:** [April 3, 2019, 9:17am UTC](https://community.sonarsource.com/t/t-sql-project-project-now-empty/8426/2 "2019-04-03T09:17:45Z")

</div>

Hey Pete,

What’s the `sonar.tsql.file.suffixes` setting like for this project? does it include `.sql`?

This would either be in a local configuration file for your project, set on the command line or (most likely) set under **Administration \> T-SQL**

Colin

---

<div class="post-metadata">

**Author:** ![pconnor](https://dub1.discourse-cdn.com/sonarsource/user_avatar/community.sonarsource.com/pconnor/32/984_2.png) [@pconnor](https://community.sonarsource.com/u/pconnor)\
**Post date:** [April 3, 2019, 9:29am UTC](https://community.sonarsource.com/t/t-sql-project-project-now-empty/8426/3 "2019-04-03T09:29:47Z")

</div>

Hi @Colin,

I’ve just had another look at it and it seems that all the suffixes were on one line in the SonarCloud Admin for the project! So just 1 entry with the value of ‘.tsql,.sql,sql’

I have set this back to 3 separate lines and it seems to be working again now. Is there an audit log for the Admin section, so we can investigate how this happened?

Thanks,  
Pete