MS SQL Server 2k standard - insuffient system resources or memory

Hi,
I have sql 2000 with sp3, on w2k with sp4. It has 3 GB RAM. I haven't set u
p the maximum memory for instance, so they are defaults from 0 to 3072 mb.
My former server worked fine.: It was sql 2000 no sp, on w2k with sp2. It ha
d 1 GB RAM.
I had't set up the maximum memory for instance, so they are defaults from 0
to 1024 mb.
and that worked fine.
My 3rd party programs are finnish accounting programs and they give me very
much error and other conflict messages. I have already checked out everythin
g from setttings and I don't believe it could be any collation problem or so
mething.
I am now wondering what happens when there's no limits of the memory usage.
Will sql use over 2 gb though it can't and give problems after or does it re
alize limits?
Does anyone know?Standard Edition of SQL Server 2000 will not use more than 2G.
It's easy to confirm this with Performance Monitor. What errros are you
getting?
Brian
"Mikko Oksanen" <anonymous@.discussions.microsoft.com> wrote in message
news:70923497-8A0B-43A1-B9FE-608215BC91CA@.microsoft.com...
> Hi,
> I have sql 2000 with sp3, on w2k with sp4. It has 3 GB RAM. I haven't set
up the maximum memory for instance, so they are defaults from 0 to 3072 mb.
> My former server worked fine.: It was sql 2000 no sp, on w2k with sp2. It
had 1 GB RAM.
> I had't set up the maximum memory for instance, so they are defaults from
0 to 1024 mb.
> and that worked fine.
> My 3rd party programs are finnish accounting programs and they give me
very much error and other conflict messages. I have already checked out
everything from setttings and I don't believe it could be any collation
problem or something.
> I am now wondering what happens when there's no limits of the memory
usage. Will sql use over 2 gb though it can't and give problems after or
does it realize limits?
> Does anyone know?
>
>|||Hello,
I looked from the performance monitor. I Noticed it also. Thank you
I get this kind of errors:
Insufficient resources to create UMS scheduler
Run-time error'-2147217900 (80040e14)':
The CREATE DATABASE process is allocating 0,75 MB on disk 'pl3135kk'.
(here the pl3135 is some temp database)
Insufficient system memory to run this query
This kind of problem. Anykind of help could do if you know or have heard thi
s kind of problems
-Mikko-
Standard Edition of SQL Server 2000 will not use more than 2G.
It's easy to confirm this with Performance Monitor. What errros are you
getting?
Brian
"Mikko Oksanen" <anonymous@.discussions.microsoft.com> wrote in message
news:70923497-8A0B-43A1-B9FE-608215BC91CA@.microsoft.com...
> Hi,
up the maximum memory for instance, so they are defaults from 0 to 3072 mb.
had 1 GB RAM.
> I had't set up the maximum memory for instance, so they are defaults from
0 to 1024 mb.
> and that worked fine.
very much error and other conflict messages. I have already checked out
everything from setttings and I don't believe it could be any collation
problem or something.
usage. Will sql use over 2 gb though it can't and give problems after or
does it realize limits?sql

MS SQL Migration From MS Access

Hi,

I am looking to move up from MS Access to MS SQL.

What is the maximum amount of fields allowed in a MS SQL Record?

In my Access database I have had to create a number of tables to hold the data. I would like to keep everything in one table for the MS SQL DB.

Is there any problems I should watch for regarding data types etc when I change over.

Many Thanks

Darrell...One record on SQL Server cannot keep more than 8060 bytes - of course you can use text fields, but they are not so convenient.
Question is - what kind of database do you have? OLTP, warehouse or something else? Do you need to normalize your data or denormalize?|||Hi,

I believe I am looking at a normalised access database, that I want to migrate from.

The data is currently split across 5 tables, using refrential integrity with primary key the unique id for each record.

With the 8060 bytes of data, is that just adding up the data type sizes for the maximum amount data fields or is there some kind of overhead to bear in mind?

Thanks

Darrell...|||Originally posted by Darrell
Hi,

I believe I am looking at a normalised access database, that I want to migrate from.

The data is currently split across 5 tables, using refrential integrity with primary key the unique id for each record.

With the 8060 bytes of data, is that just adding up the data type sizes for the maximum amount data fields or is there some kind of overhead to bear in mind?

Thanks

Darrell...

You can create table like this with warning that it is impossible to add record if total amount data is more than 8060 bytes:

create table mytable( id int
,code1 varchar(8000)
,code2 varchar(8000)
,code3 varchar(8000)
,code4 varchar(8000)
,code5 varchar(8000)
)

See BOL about data types.