require "rubygems"
require "active_record"

#change the following for your database
ActiveRecord::Base.establish_connection(
  :adapter => "sqlserver",
  :host => "hostname",
  :database => "DBname",
  :username => "myname",
  :password => "password")

class Project < ActiveRecord::Base
end

p = Project.find(1)

After running this the following error is thrown:

>ruby deletemeimworthless.rb
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.0/lib/active_record/connection_adapters/abstract_adapter.rb:212:in `log': DBI::DatabaseError: Execute (ActiveRecord::StatementInvalid)
    OLE error code:80040E37 in Microsoft OLE DB Provider for SQL Server
      Invalid object name 'projects'.
    HRESULT error code:0x80020009
      Exception occurred.: SELECT * FROM [projects] WHERE ([projects].[id] = 1) 	from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-sqlserver-adapter-1.0.0.9250/lib/active_record/connection_adapters/sqlserver_adapter.rb:337:in `execute'
	from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-sqlserver-adapter-1.0.0.9250/lib/active_record/connection_adapters/sqlserver_adapter.rb:538:in `select'
	from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.0/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache'
	from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.0/lib/active_record/connection_adapters/abstract/query_cache.rb:62:in `select_all'
	from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.0/lib/active_record/base.rb:661:in `find_by_sql'
	from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.0/lib/active_record/base.rb:1554:in `find_every'
	from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.0/lib/active_record/base.rb:1589:in `find_one'
	from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.0/lib/active_record/base.rb:1575:in `find_from_ids'
	from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.0/lib/active_record/base.rb:616:in `find'
	from deletemeimworthless.rb:18
hopefully the connection was successful...
>Exit code: 1