You cannot use certain system procedures within transactions.
sp_helpdb, sp_helpdevice, sp_helpindex, sp_helpjoins, sp_helpserver, sp_lookup, and sp_spaceused (because they create temporary tables)
sp_configure
System procedures that change the master database