rails-sqlserver/activerecord-sqlserver-adapter — Issue #165: table_name_prefix dbo. won't work for me
Author: thbar
Created: 2012-02-18 18:05:05+00:00
State: open

(I'm just discovering the adapter so please bear with me!)

I have a user whose default schema is not dbo. I tried to use this to work-around it (as recommended on the readme):

```ruby
ActiveRecord::Base.table_name_prefix = 'dbo.'
```

but this leads to:

```
TinyTds::Error: Incorrect syntax near '.'.: CREATE UNIQUE INDEX [dbo].[unique_schema_migrations] ON [dbo].[schema_migrations] ([version])
```

I was able to work around that with by changing the default schema on the user (but that's not always doable):

```sql
ALTER USER "DOMAIN\USER" WITH DEFAULT_SCHEMA = dbo;
```

Is the `table_name_prefix` trick supposed to handle what I supposed it was?