tpreto7@sapo.pt (Teresa) wrote in
news:6dabc692.0308191246.2c061943@posting.google.c om:

> 1> sp_configure locks, 10000
> 2> go
> Msg 17411, Level 16, State 1:
> Server Procedure 'sp_configure', Line 161:
> Configuration option is not unique.
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ This is telling you that
'locks'
is not a unique configuration option and it shows you the two
config
options below that map to it:


> Parameter Name Default Memory Used Config
> Value
> Run Value
> ------------------------------ ----------- -----------
> ------------
> -----------
> max engine freelocks 10 0
> 10
> 10
> number of locks 5000 1407
> 10000
> 10000

All you have to do is make config more unique. I think that's really
what you're asking, ah, of course! <g> okay, what you need to do
is:

sp_configure "number of locks", 20000
go


--
Pablo Sanchez, Blueoak Database Engineering
http://www.blueoakdb.com