Installing

Before using the role functionality, make sure Adaptive Server has additional disk space in the master database and transaction log for the columns added to the syssrvroles table. A database administrator can use the alter database command to add the additional space.

To identify the density of roles per page and log space you need for role password changes, use sp_help syssrvroles and sp_helpdb. You can then compare the values of: