MSDTC promoting a transaction only in some environments
We have a service which uses LINGTOSQL to process some updates on a remote SQL box.  On some machines everything is fine and it works without DTC enabled.  On other machines, that appear identical the transaction is being elevated to a distributed transaction and failing if it hasn’t been enabled correctly.  This is on SQL [...]

Answer Question   |  May 8, 2013  2:45 PM
DTC, SQL 2008, SQL 2008 R2

SQL 2008 R2 ‘Web Assistant procedures’
exec sp_configure ‘Web Assistant procedures’ When I execute above statement in SQL 2008 R2, I get the follwing error message Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51 The configuration option ‘Web Assistant procedures’ does not exist, or it may be an advanced option. How to correct this error? How do I install [...]

Answer Question   |  April 30, 2012  8:07 PM
SQL 2008 R2, SQL 2008 R2 error messages