make sure that the file path from the server is the same as the file path from the computer that you made the dts on.

also make sure that the web...

1. open up visual studio 2005

2. choose other project types, database project.

3. setup your db reference

4. right click on queries and choose add new query.

5. choose stored procedure script and...

finnally looks like i found the answer to my problem. there is an awe hotfix for service pack 4 that i need to apply.

http://support.microsoft.com/default.aspx?kbid=899761

I would be happy to be using 7.6 ! Thanks for the input at least i now know that is most likely not the problem. Which is bad news because...

Jo, Yes I am mesuring both from task manager and sql server total server memory in perfmon. Both readings seem to be about the same.

Chris I have a feeling its...

the server is in production, I cant keep stopping and starting it. Though I have a feeling that it will stop erroring about 5 gigs.

There is nothing but sql server...

in my sql log i see the message.

2005-09-22 23:44:36.13 spid1 Warning: unable to allocate 'min server memory' of 8985MB.

when i look at the performance monitor the...

well i stopped and started the service. i have no restarted. I do not want to do this unless i am absolutely sure.

Hi phil. we are running enterprise edition. it should support up 64 gigs of memory.

I have taken a look at tha tarticle but dont really see anything different from my...

i set the set working set size Option to 1. It still will not go over 5.18g.

The data file is about 70 gig for the main database, Split into 2 datafiles. The sql server is under a heavy load, at times we use pretty heavy queries....