How do I set TS Role in order to run certain DBC

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How do I set TS Role in order to run certain DBCCs...?

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

(Continued on next question...)

Other Job Interview Questions

• What is Open Server in Sybase?
• What is the difference in storage type of numeric and decimal data types in sybase ?
• Why am I running out of locks on the replicate side in Sybase ?
• What is the difference between an LTM and a RepAgent in Sybase?
• How to manually drop a table in Sybase
• Given a table which contains some rows with duplicate keys, how would you remove the duplicates?
• What is Replication Server in Sybase?
• How to remove row affected and dashes
• What is Trace Flags -- 5101 and 5102 in Sybase ?
• Explain the structure of Adaptive server enterprise?
• More...