Home / server / Questions / 375307
Accepted
Alex KeySmith
Asked: 2012-03-31 08:09:43 +0800 CST

Max registered users on sql server

  • 772

We are thinking of using sql users / roles for row level security.

I have read that the max is approx 32,000+/- users, because the sys.users has a smallint id.

However I've not been able to find anything absolutely conclusive.

n.b. I'm not after the number of concurrent users, but the max number of registered users.

thanks for the help

sql-server

1 Answers

  1. Best Answer

    sys.sysusers is a depreciated view for SQL Server after SQL2000. In 2005+ it reports the uid column is a small int to keep backwards compatibility, but the underlying id column is an int. sys.sysusers notes that anything above 32,767 will return null instead.

    http://msdn.microsoft.com/en-us/library/ms179871.aspx

    The newer sys.database_principals and sys.server_principals views shows the principal_id column as an int. So you would be good until 2 billion registered.

    http://msdn.microsoft.com/en-us/library/ms188786%28v=sql.105%29.aspx

    • 4