SQL Server will automatically escalate transactions from normal transactions to distributed transactions as needed. This escalation can be expensive, however.