Displaying 2 results from an estimated 2 matches for "trancount".
Did you mean:
ancount
2006 Jan 19
3
problems with migrations in sql server
...Length, COLUMNPROPERTY(OBJECT_ID(''Foo''), COLUMN_NAME, ''IsIdentity'') as
IsIdentity, NUMERIC_SCALE as Scale FROM INFORMATION_SCHEMA.COLUMNS WHERE
TABLE_NAME = ''Foo'' 54
SQL:BatchCompleted EXEC sp_helpindex Foo 54
SQL:BatchCompleted IF @@TRANCOUNT > 0 ROLLBACK TRAN 54
And finally the log file contains the following:
# Logfile created on Wed Jan 18 23:10:19 Eastern Standard Time 2006 by
logger.rb/1.5.2.4
[4;36;1mSQL (0.000000) [0;1mDBI::DatabaseError: Execute
OLE error code:80040E14 in Microsoft OLE DB Provider for SQL Server
T...
2006 Sep 18
1
SQLServer adapter fails to commit on save()
...vrStatusReport.new
:
report.x = y
:
report.save
puts report.id
This outputs a new id each time, but the record doesn''t appear in the
the table according to the SQL Server Management Console.
If I do similar in IRB, it does appear. Using the SQL Server profiler I
see
the line "IF @@TRANCOUNT > 0 COMMIT TRAN" for IRB, but not my test. If I
add
"report.connection.commit_db_transaction()" after report.save the record
does appear.
Although I never ask for transactions, it is turning on
"implicit_transactions" in SQLServer (in my test and IRB), but somehow
t...