Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Server Roles

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-06-08 : 08:00:32
Surinder writes "What is the maximum and minimum number of application roles that can be created on SQL Server in a specific instant?

In Sybase according to the manual, a maximum of 992 roles can be in effect (i.e. active) at any specific instant in time within the Sybase server. I assume we could create as many roles as we would like (e.g. 10,000), but
that only 992 could be active at once.

Your feedback is greatly appreciated.
Thanks in advance.

With best regards,

Surinder Pal Singh"
   

- Advertisement -