|
How do I set TS Role in order to run certain DBCCs...?
Sybase Interview Questions and Answers
(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 Interview Questions
| 