# sqlserver\_adapter

**URL:** <https://discuss.rubyonrails.org/t/sqlserver-adapter/46295>\
**Category:** rubyonrails-core\
**Tags:** bug\
**Created:** [September 23, 2009, 2:09pm UTC](https://discuss.rubyonrails.org/t/sqlserver-adapter/46295 "2009-09-23T14:09:24Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rob\_Nichols](https://avatars.discourse-cdn.com/v4/letter/r/b9e5f3/32.png) [@Rob\_Nichols](https://discuss.rubyonrails.org/u/Rob_Nichols)\
**Post date:** [September 23, 2009, 2:09pm UTC](https://discuss.rubyonrails.org/t/sqlserver-adapter/46295/1 "2009-09-23T14:09:24Z")

</div>

There is a bug in the activerecord-sqlserver-adapter-2.2.21 gem. The error is in:

activerecord-sqlserver-adapter-2.2.21\lib\active\_record \connection\_adapters\sqlserver\_adapter.rd

And is at line 1058.

FROM #{db\_name}INFORMATION\_SCHEMA.COLUMNS columns

should be

FROM #{db\_name}.INFORMATION\_SCHEMA.COLUMNS columns

If the period between the db\_name and INFORMATION\_SCHEMA is missed out, the database name gets appended to INFORMATION\_SCHEMA. For example, if the database name is 'database\_one', you will get an error:

Invalid object name 'database\_oneINFORMATION\_SCHEMA.COLUMNS' when you enter a connection.select.

---

<div class="post-metadata">

**Author:** ![Ken\_Collins1](https://sea2.discourse-cdn.com/rubyonrails/user_avatar/discuss.rubyonrails.org/ken_collins1/32/778_2.png) [@Ken\_Collins1](https://discuss.rubyonrails.org/u/Ken_Collins1)\
**Post date:** [September 23, 2009, 2:29pm UTC](https://discuss.rubyonrails.org/t/sqlserver-adapter/46295/2 "2009-09-23T14:29:37Z")

</div>

The SQL Server adapter is not part of Rails Core. The project is here: [http://github.com/rails-sqlserver/2000-2005-adapter](http://github.com/rails-sqlserver/2000-2005-adapter)

This bug looks familiar and there may have been a ticket or a current  
one under progress. If not please open up a Github issues, issue, for  
it.

&nbsp;&nbsp;- Thanks, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Ken

---

<div class="post-metadata">

**Author:** ![Rob\_Nichols](https://avatars.discourse-cdn.com/v4/letter/r/b9e5f3/32.png) [@Rob\_Nichols](https://discuss.rubyonrails.org/u/Rob_Nichols)\
**Post date:** [September 23, 2009, 3:00pm UTC](https://discuss.rubyonrails.org/t/sqlserver-adapter/46295/3 "2009-09-23T15:00:06Z")

</div>

You are right Ken. The issue is here:

[http://github.com/rails-sqlserver/2000-2005-adapter/issues/closed/#issue/3](http://github.com/rails-sqlserver/2000-2005-adapter/issues/closed/#issue/3)

I've added my two pennies worth.

Thank you.

Rob
