Problem: You see an error when you are previewing a database mobile business object (MBO) that uses stored procedures.
Execution failed: Stored procedure 'pubs2.dbo.byroyalty' may be run only in unchained transaction mode.
During preview, the connection is set to chained mode so the query can be rolled back. set chained off causes the current session to use unchained transaction.
Solution: Issue sp_procxmode 'pubs2.dbo.byroyalty', anymode.