Hi Tom,

Thanks again for your help with this. I ran the command like this:

USE master
go
EXEC sp_configure 'locks', '8945049'
go
RECONFIGURE WITH OVERRIDE

I expected that over night this would not fail again with locks. I was
wrong! I failed as soon as the load started because of no locks. Because
this did not work, we ran the same command but with the value of 0. It is
working alright now. I was just wondering, because you said in your earlier
email that putting the value in quotes would make it a string, do you think
because I did put the it in quotes that that's what caused the problem? I'm
just a bit confused as to why it did not work with that value..???

Thanks again!
Meg


-----Original Message-----
From: thomas.[Email Address Removed] [mailto:thomas.[Email Address Removed]
Sent: 27 November 2002 16:45
To: Meg Hardy
Cc: [Email Address Removed] RE: locks



Meg,

If you do a sp_configure locks,
it should show a config value and a run value. If the config value is set
and the run is not, then perhaps you need to re-start the server ( I don't
know if it is dynamically configured) If the config value is not set, then
perhaps in query analyzer run: USE master go EXEC sp_configure 'locks',
'8945049' go RECONFIGURE WITH OVERRIDE go

Acually, now that I look at it closer, I think that the number for the locks
is an int - not a string so try it without the quotes: USE master go EXEC
sp_configure 'locks', 8945049 go RECONFIGURE WITH OVERRIDE go

. . . Tom

Tom Zeblisky
Reuters





-----------------------------------------------------------------
Visit our Internet site at http://www.reuters.com

Get closer to the financial markets with Reuters Messaging - for more
information and to register, visit http://www.reuters.com/messaging

Any views expressed in this message are those of the individual sender,
except where the sender specifically states them to be the views of
Reuters Ltd.

________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs SkyScan
service. For more information on a proactive anti-virus service working
around the clock, around the globe, visit http://www.messagelabs.com
________________________________________________________________________


**********************************************************************
DISCLAIMER
Any opinions expressed in this email are those of the individual and not necessarily of Mondial Assistance (UK) Ltd. This email and any files transmitted with it, including replies and forwarded copies (which may contain alterations) subsequently transmitted from the Company, are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that you have received this email in error and that any use is strictly prohibited.

If you have received this email in error please notify the IT support desk by telephone on +44 (0)208 2393984 or via email to
[Email Address Removed] including a copy of this message. Please then delete this email and destroy any copies of it. Thank you.

Mondial Assistance (UK) Ltd
Mondial House
102 George Street
Croydon
CR9 1AJ

Mondial Assistance (UK) Ltd Registered in England No.1710361 Registered office as above
**********************************************************************


________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs SkyScan
service. For more information on a proactive anti-virus service working
around the clock, around the globe, visit http://www.messagelabs.com
________________________________________________________________________
MS Sql Server LazyDBA home page