MCDBA

Can anyone recomend a good book for the 70-228 exam.
I have a pretty decent sql2k admin book, i just need someting to guide me
through the exam prep.
Im a big fan of the Sybex Study Guides.
"mat" <mat@.discussions.microsoft.com> wrote in message
news:98BB2489-7DA4-402C-8A83-1F1253A2633F@.microsoft.com...
> Can anyone recomend a good book for the 70-228 exam.
> I have a pretty decent sql2k admin book, i just need someting to guide me
> through the exam prep.
>
|||Me too.
"ChrisR" <noemail@.bla.com> schrieb im Newsbeitrag
news:OgmGJmdSFHA.1172@.TK2MSFTNGP12.phx.gbl...
> Im a big fan of the Sybex Study Guides.
>
> "mat" <mat@.discussions.microsoft.com> wrote in message
> news:98BB2489-7DA4-402C-8A83-1F1253A2633F@.microsoft.com...
>

MCDBA

Can anyone recomend a good book for the 70-228 exam.
I have a pretty decent sql2k admin book, i just need someting to guide me
through the exam prep.Im a big fan of the Sybex Study Guides.
"mat" <mat@.discussions.microsoft.com> wrote in message
news:98BB2489-7DA4-402C-8A83-1F1253A2633F@.microsoft.com...
> Can anyone recomend a good book for the 70-228 exam.
> I have a pretty decent sql2k admin book, i just need someting to guide me
> through the exam prep.
>|||Me too.
"ChrisR" <noemail@.bla.com> schrieb im Newsbeitrag
news:OgmGJmdSFHA.1172@.TK2MSFTNGP12.phx.gbl...
> Im a big fan of the Sybex Study Guides.
>
> "mat" <mat@.discussions.microsoft.com> wrote in message
> news:98BB2489-7DA4-402C-8A83-1F1253A2633F@.microsoft.com...
>> Can anyone recomend a good book for the 70-228 exam.
>> I have a pretty decent sql2k admin book, i just need someting to guide me
>> through the exam prep.
>

MCDBA

Can anyone recomend a good book for the 70-228 exam.
I have a pretty decent sql2k admin book, i just need someting to guide me
through the exam prep.Im a big fan of the Sybex Study Guides.
"mat" <mat@.discussions.microsoft.com> wrote in message
news:98BB2489-7DA4-402C-8A83-1F1253A2633F@.microsoft.com...
> Can anyone recomend a good book for the 70-228 exam.
> I have a pretty decent sql2k admin book, i just need someting to guide me
> through the exam prep.
>|||Me too.
"ChrisR" <noemail@.bla.com> schrieb im Newsbeitrag
news:OgmGJmdSFHA.1172@.TK2MSFTNGP12.phx.gbl...
> Im a big fan of the Sybex Study Guides.
>
> "mat" <mat@.discussions.microsoft.com> wrote in message
> news:98BB2489-7DA4-402C-8A83-1F1253A2633F@.microsoft.com...
>

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

Maximum Memory Configurations

What is the maximum amount of memory SQL2K can address per instance using the following configuration
WIN 2003 32 bit Enterprise Edition OS with 32 GB RAM
SQL2K SP3 32 bit Enterprise Edition w/ hot fixes
AWE Enabled
/PAE switch in boot.ini
Lock pages in memory enabled for MSSQL Service Account.
The BOL says SQL2K 32 bit can address up to 8 GB of RAM on Win2K Advanced Server but has no mention of max memory allowed.
It is my understanding that each instance will be able to use all of its =
addressable RAM. In your scenario you could configure three instances =
to use 8GB of RAM and you could have a fourth using 4GB of RAM. That =
would allow 4GB of free memory for the OS to work with. Of course you =
could install more instances, but you would want to limit the amount of =
RAM each uses so that you do not run into problems by trying to allocate =
more memory than you have in the server.=20
--=20
Keith
"Douglas Luke" <anonymous@.discussions.microsoft.com> wrote in message =
news:D6F9605B-497D-49C6-9BED-FF0B19B83BC9@.microsoft.com...
> What is the maximum amount of memory SQL2K can address per instance =
using the following configuration
>=20
> WIN 2003 32 bit Enterprise Edition OS with 32 GB RAM
> SQL2K SP3 32 bit Enterprise Edition w/ hot fixes
> AWE Enabled
> /PAE switch in boot.ini
> Lock pages in memory enabled for MSSQL Service Account.
>=20
> The BOL says SQL2K 32 bit can address up to 8 GB of RAM on Win2K =
Advanced Server but has no mention of max memory allowed.

Maximum Memory Configurations

What is the maximum amount of memory SQL2K can address per instance using the following configuratio
WIN 2003 32 bit Enterprise Edition OS with 32 GB RA
SQL2K SP3 32 bit Enterprise Edition w/ hot fixe
AWE Enable
/PAE switch in boot.in
Lock pages in memory enabled for MSSQL Service Account
The BOL says SQL2K 32 bit can address up to 8 GB of RAM on Win2K Advanced Server but has no mention of max memory allowed.It is my understanding that each instance will be able to use all of its =addressable RAM. In your scenario you could configure three instances =to use 8GB of RAM and you could have a fourth using 4GB of RAM. That =would allow 4GB of free memory for the OS to work with. Of course you =could install more instances, but you would want to limit the amount of =RAM each uses so that you do not run into problems by trying to allocate =more memory than you have in the server.
-- Keith
"Douglas Luke" <anonymous@.discussions.microsoft.com> wrote in message =news:D6F9605B-497D-49C6-9BED-FF0B19B83BC9@.microsoft.com...
> What is the maximum amount of memory SQL2K can address per instance =using the following configuration
> > WIN 2003 32 bit Enterprise Edition OS with 32 GB RAM
> SQL2K SP3 32 bit Enterprise Edition w/ hot fixes
> AWE Enabled
> /PAE switch in boot.ini
> Lock pages in memory enabled for MSSQL Service Account.
> > The BOL says SQL2K 32 bit can address up to 8 GB of RAM on Win2K =Advanced Server but has no mention of max memory allowed.

Maximum Memory Configurations

What is the maximum amount of memory SQL2K can address per instance using th
e following configuration
WIN 2003 32 bit Enterprise Edition OS with 32 GB RAM
SQL2K SP3 32 bit Enterprise Edition w/ hot fixes
AWE Enabled
/PAE switch in boot.ini
Lock pages in memory enabled for MSSQL Service Account.
The BOL says SQL2K 32 bit can address up to 8 GB of RAM on Win2K Advanced Se
rver but has no mention of max memory allowed.It is my understanding that each instance will be able to use all of its =
addressable RAM. In your scenario you could configure three instances =
to use 8GB of RAM and you could have a fourth using 4GB of RAM. That =
would allow 4GB of free memory for the OS to work with. Of course you =
could install more instances, but you would want to limit the amount of =
RAM each uses so that you do not run into problems by trying to allocate =
more memory than you have in the server.=20
--=20
Keith
"Douglas Luke" <anonymous@.discussions.microsoft.com> wrote in message =
news:D6F9605B-497D-49C6-9BED-FF0B19B83BC9@.microsoft.com...
> What is the maximum amount of memory SQL2K can address per instance =
using the following configuration
>=20
> WIN 2003 32 bit Enterprise Edition OS with 32 GB RAM
> SQL2K SP3 32 bit Enterprise Edition w/ hot fixes
> AWE Enabled
> /PAE switch in boot.ini
> Lock pages in memory enabled for MSSQL Service Account.
>=20
> The BOL says SQL2K 32 bit can address up to 8 GB of RAM on Win2K =
Advanced Server but has no mention of max memory allowed.