I can open the text file and read/write to it.

I am not sure if this is related, the SQL Server startup account is a local account, but the path isnt...

Hi

Thanks all

I am actually not running from a job, i am running from Query analyzer.

If its executed from the server, it works fine, so it will work in SQL agent,...

I have heard things about proxy configuration, is this going to help in this case ?

I am thinking there must be a way of using the GUI

Thanks

Thanks for your reply, from what I read and understand, If you assign users the Agentoperator  role, they automatically inherit the role of the other 2, so basically the Agentoperator ...

Hi

Thanks for your reply, I think I am being misunderstood here, basically all I wanted to know was whether it was possible to make my application more scalable by running...

Thanks for your reply, really appreciated but moving forwards, on the issue of creating a complete backup strategy, would you have any ideas ?

Thanks

its on C:

goto view and change the option not to hide protected Os files.

cheers

Hi

Thanks for your reply Colin, I didnt quite understand the link as well, what I just noticed that setting the max server memory to 7Gb seemed to kill the system...

Hi

I think I have managed to figure out what the problem is, I reduced the max server memory to 3GB and the time the query runs has reduces significantly, i.e...

Hi

I think I have managed to figure out what the problem is, I reduced the max server memory to 3GB and the time the query runs has reduces significantly, i.e...

Hi

the machine is 32bit

The box is a dedicated sql box, what's running slower at the moment seems to be queries, compared to when AWE wasnt enabled.

What i am concerned off...

Thanks for your response, its highly appreciated. I have added the 3GB/PAE to the boot bil, I set min server memory to 1Gb and max to 7GB.

Yet, the page file...

Hi Utsab,

I have enabled the PAE switch and it still hasnt made a difference, the PF usage still hangs at 7GB.

Cheers

Hi

Thanks for your reply.

But by defauly PAE is already enabled by default in windows 2003 server, so as I understand PAE doesn't need to be added to the boot.ini file.

Please...

Hi David

Thanks for the reply, what i am trying to understand now is that what other witches/what have I done wrong.

I have read the Ms link and I believe I...