Had to make the following changes to jdbc_mssql.rb in 0.8.2 to get things working with MS SQL Sever 2003:

72c72
<         value.sub(/^\((.*)\)$/,'\1').sub(/^'(.*)'$/,'\1')
---
>         value.to_s.sub(/^\((.*)\)$/,'\1').sub(/^'(.*)'$/,'\1')
182a183,184
>         remove_check_constraints(table_name, column_name)
>         remove_default_constraint(table_name, column_name)
223a226,227
>         return [] if table_name =~ /^sysobjects/i
>         return [] if table_name =~ /^syscolumns/i

Date: 2008-12-15 18:46
Sender: David Whittington

Note, the body was supposed to say MS SQL Server 2000 not 2003.