INF: ????? ????? "????????? ???????" ?????? ??? ?????? @@

?????? ????????? ?????? ?????????
???? ???????: 156498 - ??? ???????? ???? ????? ????? ??? ???????.
??? ????? ??? ???????. ????? "??? ??" ??? ??? ??????? ??? ????.
????? ???? | ?? ????

??????

???? SQL Server 6.5 ????? ????? "@@ ??????" ? ??? ???? ?????? ??????? ?? ??? ?? ?????? ????????. ????? ????? ?????? @@ ?????? ????????? ??????? ???? ??? ?????? ????? ???? ???? ?? ????? ??? ?????. ???? ??? ??????? ????? ????? ????? ???? ????? ????? ????? @@ ?????? ?????? ??? ????.

??????? ????

????? ???????? ????? ?????? ?????? ????? ?????? (SA) ?? ISQL ?? ISQL/w:
   use master
   go
   if (exists (select * from sysobjects
      where name = 'sp_currentopts'))
      drop procedure sp_currentopts
   go
   if (exists (select * from sysobjects
      where name = 'sysuseropts'))
      drop table sysuseropts
   go
   create table sysuseropts
   (optid      int      NOT NULL,
   options_set    varchar(25) NOT NULL)
   go
   insert into sysuseropts values (0,'NO OPTIONS SET')
   insert into sysuseropts values (1,'DISABLE_DEF_CNST_CHK')
   insert into sysuseropts values (2,'IMPLICIT_TRANSACTIONS')
   insert into sysuseropts values (4,'CURSOR_CLOSE_ON_COMMIT')
   insert into sysuseropts values (8,'ANSI_WARNINGS')
   insert into sysuseropts values (16,'ANSI_PADDING')
   insert into sysuseropts values (32,'ANSI_NULLS')
   insert into sysuseropts values (64,'ARITHABORT')
   insert into sysuseropts values (128,'ARITHIGNORE')
   insert into sysuseropts values (256,'QUOTED_IDENTIFIER')
   insert into sysuseropts values (512,'NOCOUNT')
   insert into sysuseropts values (1024,'ANSI_NULL_DFLT_ON')
   insert into sysuseropts values (2048,'ANSI_NULL_DFLT_OFF')
   go
   grant select on sysuseropts to public
   go
   create procedure sp_currentopts as
   if @@options <> 0
      select options_set
      from master.dbo.sysuseropts
      where (optid & @@options) > 0
   else
      select options_set
      from master.dbo.sysuseropts
      where optid = 0
   go
   grant execute on sp_currentopts to public
   go
				
??? ?? ????? sp_currentopts ??? ???? ??? ????? ????? ?????? ???????? ?????? ????? ???????. ??? ???? ??????? ????? ?? ????? ????? ?????? (DBA) ????? ??????? ???????:
   sp_configure 'user options', 1400
   go
   reconfigure
   go
				
????? ?????? ???? ??? ?????? ?????? ?? ????? sp_currentopts ???????:
   options_set
   -------------------------
   ANSI_WARNINGS
   ANSI_PADDING
   ANSI_NULLS
   ARITHABORT
   QUOTED_IDENTIFIER
   ANSI_NULL_DFLT_ON
				
????? ??? ???? ??? ?????????? ?????? ?????? ??? ???? ??? ??? ?????? ??? 0 (???) sp_configure '?????? ????????' ????? ? ?? ?????? ??? SET ON ANSI_WARNINGS ?? ????? sp_currentopts ???????:
   options_set
   -------------------------
   ANSI_WARNINGS
				

???????

???? ???????: 156498 - ????? ??? ??????: 04/???? ??????/1435 - ??????: 3.0
????? ???
  • Microsoft SQL Server 6.5 Standard Edition
????? ??????: 
kbnosurvey kbarchive kbmt kbhowto kbinfo kbusage KB156498 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????156498

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com