reposting: maximum number of database users in sql2k

Hi All,
note: I am discussing the number of users in the database not the user
'connections'
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 database users in sql2k.
(Could not find it in the sql books online)
Thanks
Vikram
--
Vikram Vamshi
Eclipsys Corporation> Is there any Microsoft Documentation which states that 16379 is the
maximum
> number of database users in sql2k.
Yes.
http://support.microsoft.com/?id=303879
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/|||That is exactly what I was looking for.
Thanks
Vikram
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:uSozZCPvDHA.2712@.tk2msftngp13.phx.gbl...
> > Is there any Microsoft Documentation which states that 16379 is the
> maximum
> > number of database users in sql2k.
> Yes.
> http://support.microsoft.com/?id=303879
>
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
>|||This limitation is documented here:
http://support.microsoft.com/default.aspx?scid=kb;en-us;303879
For that number of users consider using Windows Authentication and adding
domain user groups as database users rather than adding the users
individually. This should be much easier to manage than user-level security.
--
David Portas
--
Please reply only to the newsgroup
--