Q3.1: How to set TS Role

Some DBCC commands require that you set TS Role in order to run them. Here's how to set it:

Login to Server as sa and perform the following: 

sp_role "grant", sybase_ts_role, sa    
go
set role "sybase_ts_role" on
go