maximum number of database users in sql2k

Hi All,
I was trying to find some documentation from microsoft which specifies the
maximum number of users that can be created in a single sql2k database.
We seem to be hitting the limit at 16379.
The error raised is:
<<
Server: Msg 15065, Level 16, State 1, Procedure sp_grantdbaccess, Line 160
All user IDs have been assigned.
>>
The following section of code from sp_grantdbaccess suggests that 16379 is
the limit:
/////////////////////////////////////////////
-- OBTAIN NEW UID (RESERVE 1-4) --
if user_name(5) IS NULL
select @.uid = 5
else
select @.uid = min(uid)+1 from sysusers
where uid >= 5 and uid < (16384 - 1) -- stay in users range
and user_name(uid+1) is null -- uid not in use
if @.uid is null
begin
raiserror(15065,-1,-1)
return (1)
end
/////////////////////////////////////////////
Can anyone confirm this?
Is there any Microsoft Documentation which states that 16379 is the maximum
number of users in sql2k.
(Could not find it in the sql books online)
Thanks
Vikram
--
Vikram Vamshi
Eclipsys CorporationThe maximum number of connection is 32767.
Run sp_configure 'user connection' on your server if it is
set differently on your server.
Hope to help.
>--Original Message--
>Hi All,
>I was trying to find some documentation from microsoft
which specifies the
>maximum number of users that can be created in a single
sql2k database.
>We seem to be hitting the limit at 16379.
>The error raised is:
><<
>Server: Msg 15065, Level 16, State 1, Procedure
sp_grantdbaccess, Line 160
>All user IDs have been assigned.
>The following section of code from sp_grantdbaccess
suggests that 16379 is
>the limit:
>/////////////////////////////////////////////
> -- OBTAIN NEW UID (RESERVE 1-4) --
> if user_name(5) IS NULL
> select @.uid = 5
> else
> select @.uid = min(uid)+1 from sysusers
> where uid >= 5 and uid < (16384 - 1) --
stay in users range
> and user_name(uid+1) is null --
uid not in use
> if @.uid is null
> begin
> raiserror(15065,-1,-1)
> return (1)
> end
>/////////////////////////////////////////////
>Can anyone confirm this?
>Is there any Microsoft Documentation which states that
16379 is the maximum
>number of users in sql2k.
>(Could not find it in the sql books online)
>Thanks
>Vikram
>--
>Vikram Vamshi
>Eclipsys Corporation
>
>.
>|||obaid,
I did get the infomration regarding the user 'connections' from books
online.
Here I am trying to get the information regarding the number of 'database
users' that can be created in a database.
Vikram