备课平台看不到知识结构之后怎么办？

　　各位不要着急！看不到知识结构大体上是因为在安装时出现了意外或者是由于还原数据库时，以前备份的数据库有问题造成的。解决的办法是！
　　在开始菜单里程序/SQL查询分析器/选择WINDOWES模式验证，把如下的SQL语句拷贝到可见的视窗中注意选择的数据库一定是newess_hts_db（默认是master的数据库可选择的）看到一个绿颜色的按钮点击执行！

if not Exists(Select * from syscolumns where id in (Select id from sysobjects
where name='MRelate') and name='DBTypeRoll')
　Alter table MRelate add
　　DBTypeRoll char(2)

if not Exists(Select id from sysobjects
where name='MListView_FindDUDT')
　CREATE TABLE [dbo].[MListView_FindDUDT] (
　　　[MFileName] [varchar] (101) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]

if not Exists(Select * from syscolumns where id in (Select id from sysobjects
where name='TDPlan') and name='isteach')
Alter table TDPlan add
isteach int

Go

if not Exists(select * from warrant where Warrantid=11)
insert into warrant(Warrantid,warrantname,ModelName) values (11,'检查空链接','资源库管理')

if not Exists(select * from warrant where Warrantid=12)
insert into warrant(Warrantid,warrantname,ModelName) values (12,'检查垃圾文件','资源库管理')

if not Exists(select * from warrant where Warrantid=28)
insert into warrant(Warrantid,warrantname,ModelName) values (28,'标准教案模板编缉','备课平台')

if not Exists(select * from warrant where Warrantid=29)
insert into warrant(Warrantid,warrantname,ModelName) values (29,'清空教案模板','备课平台')

if not Exists(select * from warrant where Warrantid=30)
insert into warrant(Warrantid,warrantname,ModelName) values (30,'评价教案','备课平台')

update warrant set warrantname='指定/撤销优秀教案' where Warrantid=22
update warrant set warrantname='转发他人教案' where Warrantid=23
update warrant set warrantname='转移他人教案' where Warrantid=24
update warrant set warrantname='导出他人教案' where Warrantid=25
update warrant set warrantname='清空教案' where Warrantid=26
update warrant set warrantname='教案模版编缉' where Warrantid=27

Go

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetTypeName]') and xtype in (N'FN', N'IF', N'TF'))
drop function [dbo].[GetTypeName]
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE FUNCTION GetTypeName (@mBookCode nvarchar(30),@DBType nvarchar(30),@TypeID nvarchar(30))
RETURNS　nvarchar(30)　AS
BEGIN
DECLARE @TypeName varchar(40)
DECLARE MType_cursor CURSOR FOR
SELECT TypeName FROM MType
WHERE BookCode=@mBookCode AND DBType=@DBType AND rtrim(ltrim(STR(TypeID)))=rtrim(ltrim(@TypeID))


OPEN MType_cursor
FETCH NEXT FROM MType_cursor
INTO @TypeName
IF @@FETCH_STATUS <> 0
BEGIN
select @TypeName=''
END
CLOSE MType_cursor
DEALLOCATE MType_cursor
RETURN @TypeName
END

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

if not Exists(Select * from syscolumns where id in (Select id from sysobjects
where name='TDPLan') and name='NewText')
Alter Table TDPLan
Add NewText Text

if not Exists(Select * from syscolumns where id in (Select id from sysobjects
where name='TDPLan') and name='ID')
Alter Table TDPLan
Add ID int IDENTITY(1,1)

Go

DECLARE @tmpptr binary(16), @ptrval binary(16), @TmpString varchar(1024), @Len int, @i int, @NewLen int, @ID int
declare test cursor for
Select ID from TDPlan where HTMLTextent like '%<%' or HTMLTextent like '%>%' or HTMLTextent like '%
%'
open test
fetch next from test into @ID
while @@fetch_status=0
begin
Update TDPlan Set NewText='' where ID=@ID
Select @TmpPtr=TEXTPTR(NewText) From TDPlan where ID=@ID

　Select @len=1024, @i=0, @newlen=0
while @len=1024
begin
Select @TmpString=SubString(HTMLTextent, @i*1024+1, 1024) From TDPlan where ID=@ID
Select @len=len(@TmpString)
Select @TmpString=Replace(@TmpString, '>', '&gt;')
Select @TmpString=Replace(@TmpString, '<', '&lt;')
Select @TmpString=Replace(@TmpString, '
', '&lt;BR&gt;')
UPDATETEXT TDPlan.NewText @TmpPtr NULL 0 @TmpString
Select @i=@i+1
end
UpDate TDPlan Set HTMLTextent=NewText where ID=@ID
fetch next from test into @ID
end
Close Test
Deallocate Test

Go

Alter Table TDPlan
Drop COLUMN NewText,
Column ID

Go
update TDPlan set isteach=1

Go

CREATE UNIQUE CLUSTERED
INDEX [PK_MBaseInfo] ON [dbo].[MBaseInfo] ([MaterialCode])
WITH
PAD_INDEX
,FILLFACTOR = 80
,DROP_EXISTING
ON [PRIMARY]

CREATE UNIQUE CLUSTERED
INDEX [MRelate_i1] ON [dbo].[MRelate] ([BookCode], [NodeID], [MaterialCode], [DBType])
WITH
PAD_INDEX
,FILLFACTOR = 80
,DROP_EXISTING
ON [PRIMARY]

Go
IF NOT EXISTS (SELECT name FROM sysindexes
WHERE name = 'sss')
CREATE
INDEX [sss] ON [dbo].[SInfo] ([BookCode])
WITH
PAD_INDEX
,FILLFACTOR = 80
ON [PRIMARY]

Go
IF NOT EXISTS (SELECT name FROM sysindexes
WHERE name = 'MRelate_2')
CREATE
INDEX [MRelate_2] ON [dbo].[MRelate] ([ResStatus])
WITH
PAD_INDEX
,FILLFACTOR = 80
ON [PRIMARY]
Go
IF NOT EXISTS (SELECT name FROM sysindexes
WHERE name = 'MRelate_MCode')
CREATE
INDEX [MRelate_MCode] ON [dbo].[MRelate] ([MaterialCode])
WITH
PAD_INDEX
,FILLFACTOR = 80
ON [PRIMARY]

if not Exists(Select id from sysobjects
where name='DsDBVersion')
CREATE TABLE [dbo].[DsDBVersion] (
[VersionNum] [varchar] (20)
)
GO
ALTER TABLE MbaseInfo ALTER COLUMN Profession varchar(40)
GO
if not Exists(Select * from DsDBVersion)
INSERT INTO DsDBVersion VALUES ('DS6.1 Service Pack 1')
如果成功你会在看到视窗的下面出现：