New day new problem with SQL. Event viewer gives me this error:
Error : 2610, Severity: 22, State: 1
Could not find leaf row in nonclustered index 'iDate' that corresponds to
data row from logical data page 105947, row offset 4 during update index
attempt after data page split.
According to the books the solution is as follows, but I have a few questions.
<db_name> I assume in our case is "Emerald2" do I put it in <> or ()
<system_table_name> is this "iDate" again <> or ()
Will the following script FIX the problem? Do I need to get all users and
Radius off the database?
-------------
USE master
go
sp_dboption <db_name>,single,true
go
USE <db_name>
go
CHECKPOINT
go
sp_fixindex <db_name>,<system_table_name>,1
go
USE master
go
sp_doption <db_name>,single,false
go
USE <db_name>
go
John C. Lange, Sr. PALACE dot NET, INC.
microjl@palacenet.net MICRO-TECH Computers, Inc.
608.742.1601 & 6980 1918 New Pinery Road
http://www.palacenet.net/ Portage, WI 53901
Visit our online store @ http://www.microt.com/
Authorized iPSwitch WebVar @ http://www.microt.com/iPSwitch/index.html
--- __o
--- _-\<,_ Fastest Service in Town
--- (_)/ (_)