在SQl  server  2000 中，我的表中字段含有“PassWord” －[UserPassWord],而在执行的时候，SQl Sever 在编译执行的时候进行了替换。给出的提示为：出于安全，进行了替换。
     为此我将其做了如下改动：
    
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER    view v_registerDetail with schemabinding
as
SELECT
      dbo.registersys.userid,
      dbo.registersys.studentname,
      dbo.SubjectSys.Subject,
      dbo.fdzlist.fdzname,
      dbo.UserPassWordSys.UserPassword,
      dbo.stusignsys.studykindid,
      dbo.StudyKindList.StudyKind,
      dbo.registersys.subjectid,
      dbo.registersys.fdzid,
      dbo.registersys.stu_level,
      dbo.registersys.archieveid,
      dbo.registersys.rx_level,
      dbo.stusignsys.TpID,
      dbo.stusignsys.pic1url  
FROM  dbo.registersys INNER JOIN dbo.stusignsys ON  dbo.registersys.archieveid = dbo.stusignsys.archieveid
                      INNER JOIN dbo.fdzlist ON     dbo.registersys.fdzid = dbo.fdzlist.fdzID
                      INNER JOIN dbo.SubjectSys ON  dbo.registersys.subjectid = dbo.SubjectSys.SubjectID AND dbo.registersys.stu_level = dbo.SubjectSys.Stu_level
                      INNER JOIN dbo.StudyKindList ON dbo.stusignsys.studykindid = dbo.StudyKindList.StudyKindID
                      INNER JOIN dbo.UserPassWordSys ON dbo.registersys.userid = dbo.UserPassWordSys.UserID
          
          

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

并且创建了索引：
   Create unique clustered index  vs on  v_registerDetail(Userid)