Beau's tumblr

By default, public users don’t have access to view definitions in sqlserver 2005.

The activerecord-sqlserver-adapter requires view definitions to execute select_all on them.

This will give you a headache.

If you see an error that looks like “There is no text for object ‘view’”, then you should do this:

USE database
GO
GRANT VIEW Definition TO PUBLIC