This option is not available in SQL2000.

Mark.
www.allisonmitchell.com

-----Original Message-----
From: Adil Basha [mailto:[Email Address Removed] 12 March 2002 11:35
To: dba lazy
Subject: spin counter very urgent pls help


Hi all,

i am in a big fix

in sp_configure
i enabled it to advanced options by giving

exec sp_configure 'show advanced options',1
reconfigure

it went fine
but went i wanted to make spincounter =10000
i gave this command

exec sp_configure 'spin counter',10000

I got this error
Server: Msg 15123, Level 16, State 1, Procedure
sp_configure, Line 78
The configuration option 'spin counter' does not
exist, or it may be an advanced option.

Valid configuration options are:

pls help me out in correcting this
i am using sqlserver 2000 in winnt 4

TIA
Adil


__________________________________________________
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email!
http://mail.yahoo.com/

---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, please telephone or email the sender and delete this message and any attachment from your system. If you are not the intended recipient you must not copy this message or attachment or disclose the contents to any other person.

For further information about Clifford Chance please see our website at http://www.cliffordchance.com or refer to any Clifford Chance office.
MS Sql Server LazyDBA home page