SQLWebpedia

Trying to install any post SP2 hotfix, I kept getting this error message in the Summary.log file (C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix)

MSP Error: 29537 Cannot promote the transaction to a distributed transaction because there is an active save point in this transaction

I found no help on the net, so created this post in case it helps others. I had a db trigger that logs to another server and this caused the error. I disabled the db trigger and worked like a charm. This error also comes up when you are doing a snapshot for replication.