# Chef Inspec Sql\_Session

**URL:** <https://discourse.chef.io/t/chef-inspec-sql-session/16120>\
**Category:** Chef InSpec\
**Created:** [October 22, 2019, 11:52am UTC](https://discourse.chef.io/t/chef-inspec-sql-session/16120 "2019-10-22T11:52:03Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![thangaraj-chef](https://avatars.discourse-cdn.com/v4/letter/t/bbe5ce/32.png) [@thangaraj-chef](https://discourse.chef.io/u/thangaraj-chef)\
**Post date:** [October 22, 2019, 11:52am UTC](https://discourse.chef.io/t/chef-inspec-sql-session/16120/1 "2019-10-22T11:52:03Z")

</div>

Hi,

I did tried to get the MSsql server configuration Inspec. Am getting error as i use below control

describe sql.query("Exec Sp\_Configure 'Ad Hoc Distributed Queries' as result").row(0).column('config\_value') do  
its('value') { should cmp \> '0' }  
end

It's throwing error like

SQL Column  
[FAIL] value should cmp \> "0"

```
 expected it to be > "0"
      got: ""

 (compared using `cmp` matcher)
```