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