use sybsystemprocs有错误

bysea51

1>; use sybsystemprocs
2>; go
Msg 926, Level 14, State 1:
Line 1:
Database 'sybsystemprocs' cannot be opened. An earlier attempt at recovery
marked it 'suspect'. Check the SQL Server errorlog for information as to the
cause.

－－－－－－－－－－－－－－－－－－－－－－－－－

请问这是怎么回事，谢谢

冷月无声

故障现象：

在$SYBASE/install目录下的数据库系统日志中发现错误号为926，严重级别为14，错误消息为：

Database 'xx' cannot be opened - it has been marked SUSPECT by recover Explanation

解决方法：

1．以SA 身份用ISQL 登 录 到SQL Server

1>;sp_configure "allow updates", 1

2>;go

2>;reconfigure with override

2>;go

1>;update master..sysdatabases

2>;set status =-32768

3>;Where name="database_name"

4>;go

1>;shutdown with nowait

2>;go

2． 重新启动SQL Server, 再以SA身份登录到SQL Server.

1>;update master..sysdatabases

2>;set status=0

3>;Where name="database_name"

4>;go

1>;sp_configure "allow updates" ,0

2>;go

1>;reconfigure with override

2>;go

3. 重新配置

1>;sp_dboption database_db，‘trunc log on chkpt’，true

2>;go

1>;sp_dboption database_db，‘select into/bulkcopy ’，true

2>;go

bysea51

真的万分感谢

yyh

我现在也碰到这个问题，
1>; sp_configure "allow updates",1
2>; go
Msg 926, Level 14, State 1:
Line 1:
Database 'sybsystemprocs' cannot be opened. An earlier attempt at recovery
marked it 'suspect'. Check the SQL Server errorlog for information as to the
cause.
Msg 2812, Level 16, State 4:
Line 1:
Stored procedure 'sp_configure' not found. Specify owner.objectname or use
sp_help to check whether the object exists (sp_help may produce lots of output)

怎么办？