search for: col_length

...CREATE TABLE schema_info (version int) 54 SQL:BatchCompleted CREATE TABLE schema_info (version int) 54 SQL:BatchCompleted select * from CREATE TABLE schema_info (version int) 54 SQL:BatchCompleted SELECT COLUMN_NAME as ColName, COLUMN_DEFAULT as DefaultValue, DATA_TYPE as ColType, COL_LENGTH(''schema_info'', COLUMN_NAME) as Length, COLUMNPROPERTY(OBJECT_ID(''schema_info''), COLUMN_NAME, ''IsIdentity'') as IsIdentity, NUMERIC_SCALE as Scale FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ''schema_info'' 54 SQL:BatchCo...

...t;"CIA flight...", "flightdate(1i)"=>"2005", "flightdate(2i)"=>"11", "flightdate(3i)"=>"24"}} [4;35;1mReport Columns (0.070000) SELECT COLUMN_NAME as ColName, COLUMN_DEFAULT as DefaultValue, DATA_TYPE as ColType, COL_LENGTH(''reports'', COLUMN_NAME) as Length, COLUMNPROPERTY(OBJECT_ID(''reports''), COLUMN_NAME, ''IsIdentity'') as IsIdentity, NUMERIC_SCALE as Scale FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ''reports'' [4;36;1mSQL (0.050000)...

...E error code:80004005 in Microsoft OLE DB Provider for SQL Server Cannot create new connection because in manual or distributed transaction mode. HRESULT error code:0x80020009 Exception occurred.: SELECT COLUMN_NAME as ColName, COLUMN_DEFAULT as DefaultValue, DATA_TYPE as ColType, COL_LENGTH(''S_RESIT I''ve tried using transactions in rails but to no avail, if I have 10 windows open and refresh all at once, several windows will produce that error. MS suggests (http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B272358): Use a server-side or client-side curs...

I am unable to get ActiveRecord session support to work under 2.x against a SQL Server database. I''m starting to wonder if anyone is running 2.x against SQL Server? Is anyone running under the following configuration: Rails 2.x SQL Server 2000 DB (using AR adapter in ODBC mode) AR store for ActionController session store. I''d like to chat with you if you are. Thanks, Wes --