Sybase Question: Download Questions PDF
How do I set TS Role in order to run certain DBCCs?
Answer:
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
Login to Server as sa and perform the following:
sp_role "grant", sybase_ts_role, sa
go
set role "sybase_ts_role" on
go
Download Sybase Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Differences between clustered and non-clustered in Sybase? | What is Intimate Shared Memory or ISM? |