FIX: SQL Server 6.5 Service Pack 1 Fixlist

?????? ????????? ?????? ?????????
???? ???????: 153096 - ??? ???????? ???? ????? ????? ??? ???????.
??????? ?? ????? ????????? ?????? ????????? ???????? ???? ?? ??????? ?? ??????? Microsoft SQL Server 6.5 Service Pack 1. ????? ???? ?????? Service Pack 1 ?? ???? ????? ???????. ????? ?? ?????????? ???? ????? ????? ???????.

?????? ?????? ?? ??? ????? ?????? ??????? ???? ????????? ???. ??? ?? ??????? ????? ??? ???????? ??? ??? ??? ???? ?????? ?????.

????? ??????? ???? ?? ??????? ?? ???? ?????? 1


?????? ????? ????? ????????

Q151301: FIX: dbcursorfetchex() Can Cause Blocking in DB-Library
		

?????? odbc

Q153694: FIX: SQLNumResultCols Fails with Incorrect Syntax Near 'SET'
Q153908: FIX: 16-bit Driver Times Out on Async Calls to SQLTables
		

?????? ??????

Q149938: FIX: AV on INSERT of UNIONed SELECTs to Table With DEFAULTs
Q149939: FIX: ROLLBACK of TRUNCATE TABLE May Cause Error 3301, AV
Q150775: FIX: CREATE TABLE in Stored Procedure May Fail With Error 1750
Q150894: FIX: LOAD TRAN May Fail With Handled AV
Q150896: FIX: SH_PAGE Locks May Be Held on Inner Tables of JOINs
Q150897: FIX: LOAD TRAN May Fail With Error 1511
Q150900: FIX: UPDATE May Fail With Error 107
Q151111: FIX: DECLARE CURSOR on Temp Table with FOR UPDATE Causes AV
Q151590: FIX: Error 4409 Generated When Using Multiple Database Views
Q151591: FIX: DBCC Checkident Always Reports the Seed Value as Current
Q151693: FIX: Err Msg "Unknown Token Received from SQL Server"
Q151765: FIX: SELECT INTO Inside a Temp Procedure Causes Client to Hang
Q151985: FIX: SELECTs from SYSPROCESSES Result in Access Violation
Q151988: FIX: 1108 Errors with Heavy Tempdb Activity
Q152353: FIX: Select with CASE Statement Inside View Can Cause Client AV
Q152416: FIX: sp_processmail Will Only Process One Query per Execution
Q152615: FIX: Syntax Error in SELECT List May Cause Handled AV
Q152690: FIX: Count(*) May Not Return Result Set
Q152709: FIX: Update of BLOB Data w/SQL Server 2.65.0201 Driver Stops
Q153006: FIX: Dump or Load w/Tape Devices Results in Errors, AVs
Q153079: FIX: SQL Server Stops w/ Temporary Procedure in a Transaction
Q153186: FIX: Filtered Stored Procedures Cannot Reference Multiple Tables
Q153455: FIX: Multiple "LEFT OUTER JOIN" in FROM Clause May Cause Error
Q153780: FIX: sp_droppublisher Does Not Clear 'pub' Server Option
Q153802: FIX: Deadlock During Cursor Update Causes CPU Spin and Spinloop
Q153803: FIX: GRANT ALL Fails to Give Permissions on Stored Procedures
Q153836: FIX: SQLGetData Fails on Multiple Active Statement Handles
Q153851: FIX: AV if 4 or More Correlated Subqueries with Self-Join
Q153855: FIX: IRL can cause 3307, OS error 6, unhandled server level AV
Q153954: FIX: Checkpoint Process Deadlock Results in Errors 603, 3314
Q153961: FIX: Full Memory and Cursors Cause AVs, 707, 706, and Spins
Q153987: FIX: AV Error Using Temp Table and Cursor in Stored Procedure
Q153992: FIX: Cannot Rename a Column with a Quoted Identifier
Q154018: FIX: AV in Update Mode When Script Is Run Twice
Q154047: FIX: SQL Terminates on Delete Table with 15 Self-References
		


FIX: dbcursorfetchex() ?? ????? ??????? ?? ????? - DB

151301 ????? #: NT 15039 (6.50)
????? ???? | ?? ????

?? ??? ??????

???????

??? ??? ????? DB ????? ??????? dbcursorfetch() ?? dbcursorfetchex() ????? ?? ???? ????? ????, ??? ????????? ??????? dbcursoropen() ?? dbclose() ?? ?????? ????? ???? ???????? ??? DBPROCESS. Sp_who ? sp_lock ????? ?? blockage ??? ???? ?????? ?? ???? ????? ????? DB.

??????? SQLNumResultCols ??? ????? SQLPrepare ????? SELECT ???? ????? ??? ????????? ???? ?? ????? ??????? ??:
szSqlState = "37000" ? pfNativeError = 156
szErrorMsg = "[Microsoft] [SQL ODBC ?????? ????? ????] [SQL Server]
???? ???? ??? ???? ?????? ?? ?????? ???????? 'SET'."

????? ?????? ??? ??????? ODBC 16-?? ???????? ?????? Microsoft SQL Server ????? ODBC ??????? 2.65.0201 SQLTables() ????? ?? ??? ??? ?????? ??? '?????? ??????' ???? ??????? ?????? ??? ????? ???????? ???????? ??????.

???? ??? ??????? ?? ?? ????? ????? ???? ??????? ? Windows NT ?????? ??????? ??????. ???? ????? ????? ???? ????? ??? ????? ?? ?????? ??????? ????? ?????? ?? ??????? ????? ??? ???? ????????? ??????.

???? ?? ???? ????? ??? ???? ?? UNION ?????? SELECT ?? ???? ??? "?????? ????" ???????.

??? ??????? TABLE ????? ?? ??????? ?? ???? ??? ??? 3301 "????? ??? ??? ???? ????? ?? Syslogs (logop 42)" ? ??? ?????? ???? ??????.

??? ??? ?????? ???????? ????? ??? ???? IDENTITY ? TRUNCATE ?? ????? ?? ???? ?????? ?????? ???? ???? ??? ??? ????? ? ???? ?? ???? ??? ???????.

?? ???? ????? ????? ???? ?????? ??? ???? ?? ???? ?? ???? ?? ????????? ?????????? ?? ?????:
??? ????? ??? ???? ??? ????? ???? ??????? ??????? ?? ????? voidptr.
????? msg 1750 ????? 16, 0
??? ???? ??? ????? ?????. ???? ??????? ???????.

????? ?? ???? ?????? ?? ???????:
udwritem: ???? ??????? ??? 6 (?????? ?? ????.) ??? ??????....
ex_testhandle: ????? ??? ???? ??????? ??????? ? ?????? = 0x17a7f10 ? ????? = 0x17a7f10
exception_access_violation

???? ?????? AV ?? ??? ?????? ???? ??? ????? ??????. ???? ?? ???? ??? ???? ??? ????????? SQL Server ? ??????? ??? ????? ??????. ?? ??? ????? ????? ????? ?????? ?? ??????.

?? ??? ??????? ???? ????? ???? ???????? ??? ????? ??????? join(s) ???? SELECT.

??? ??? ??? ????????? ????? ????? ??? ????? ??????? ?????? CREATE ??????? ???????? INDEX ??? ???? ???? (> MB 150) ? ?? ???? ???????? ????? ?? ??? 1511.
1511 ???: ???????: ???? 20 ?: 8
?? ???? ??? reconciled ?? ??? ????????

?? ???? ??????? ???? 204 ??????? ?? ????? ??????? ? ?? ???? UPDATES ???????? ?????? ?? ???? ??? 107.
????? msg 107 ????? 15? 1
????? ?????? '???' ??? ?????? ?? ??? ???? ?? ??? ?????? ??? ???????? ?? ?????????

???? ????? ????? "???? ?????? ??????" ????? ????? UPDATE FOR ?? ????? ?????? ?? ????? ??????? ??? ???? ??????? ??? ??? ?????? ?? ????? SELECT ???? ????.

???? ?????? ?? ????? ????? 4409. ???? ??????? ?????? ??? ????? ????? ????? ?????? ?? ??????? ?? ??? ????? ???? ??? ????? ??????? ??? ?????? ?????????. ??? ???? ??????:

??? ??? ???? viewA ? viewC ?? ????? ???????? ???????? "?" viewB ?? ????? ?????? pubs (????????) ? ??? ???? viewA * ?? viewB ? viewB ????? * ?? viewC ? viewC ????? * ?? sysdatabases. ? ??? ?? ????? ???? SQL ????? ????? ???? ???? ????? ??? * ?? viewA. ??? ????? ????? SQL Server ?? ????? ???????? ???????? ?????? ??????? ????? ?? ????? ???????? ???????. ????? ?? ??? ??????? ????? ?????? ????? ????? ??? ????? ??? 4409 ??? pubs (????????) ?? ?? ??? ?? ???????.

???? ?? ???? ??? ?????? ??? ??? ????? ?????? ??? ? ??? ????? ?? ?? ?????? ?????? viewC ?? ????????? ????? ????? ???? ??? ?? ????? ?????? ????.

??? ????? dbcc checkident, ?????? ?????? ??????? ??? ??? ??? ??????? ????? ?? ????? ?????? ??????.
?????? ?? ??????? ??????: ???? ?????? ??????? '1' ? ???? ?????? ?????? '14'. ????? ??????? DBCC. ??? ??? DBCC ????? ????? ???????? ???? "????? ??????".

????? ???? dbcc ????? ? ??? ??? ??? ?? ??? ????? ?????? ???? ???????. ??? ????? ?? ???? ???? ?????? ??????? ????? ???? ??? ????? ?????? ???????.

??? FIX: ????? "????? ?????? ??? ???????? ???????? ?? SQL Server"

151693 ????? #: NT: 15056 (6.50)

??? ????? ?????? ????? ??????? ??? ???? ?? ???? ?????? ????? ????? ????? ??? ???? ???? SQL Server ????? ????? ??? ????? ?????? ?????. ??? ????? ??? ?????? ?? ???? ????? ???? ?????? ??? ???? ???? ????? ????? ???????:
?? ?????? ?? SQL Server ????? ?????? ??? ?????.

?? SQL Server ??????? 6.5 ? ????? ????? ???? ???? ???? ????? ??? ????? SELECT INTO ???? ?????? ?? ?????????. ?????? ??? ?????? ??????? ?? ?? ??? ????? ?????? ??? ??????. ??????? ???? ???????? ???????? ??? ??????? ?????? ????? ????? 95 ??????? ????? ??????? ?? ??????? ????? ?????? ???? ????. ??? ?? ???? ????? ????? ?? ??????? ?? SQL Server ??? ???? ???? ????????? ????? ?? ??? ??????? ???????.

??? ????? ????????? ????? ??????? (SMP) ? ?? ??????? ?????? ??? ????????? ????? sysprocesses ?????? ??????? ???? ?????? ???? ??????? ???? ????? ?????? ???? ???????. ?? ????? ????? ?????. ????? ???? ??????????? ??? ?????? ?????? ??? ???:
findwaitfor+0x2f
ins_sysproc+0x7fc
make_fake+0xe8
s_setuptables+0x2bc
s_execute+0x7d8
sequencer+0x23f
execproc+0xfb7
s_execute+0xb8c
sequencer+0x23f
language_exec+0x65e
				

FIX: ????? 1108 ?? ???? Tempdb ????

151988 ????? #: NT: 15209 (6.50)

???? ??? ?????? SQL ?? ?????? ?? ???? tempdb "?" ??? "?" deadlocks ??? ????? 1108 ?? ??? ????? ? ??? ??????. ???? ????? ????? ???????:
1108 ???: ???????: ???? 21 ?: 1
?? ???? ????? ????? ??? 944 ????? ???????? 2. ???? ???? 0 ???? ?????? 0?
?????? 0 ?? ???? ?? ????? ???? ????-49604 ???? ?????? 0? ?????? 0
?? ???? ??? deallocated. ????? CHECKALLOC DBCC

????? ?????? ??? ????? 1108 ?? tempdb ??? ???? ??? ????? ????? ??????? ???? ??? ??????? ??? ???? ???? ??? ?? ????? ????? "? ??? ???? ??? backout. ?????? ?????? ?? ?????? ??????? ???? ??? ???? ?? ??? ???? ????? ???? ???? ???? ?? errorlog.

FIX: ????? ?? ???? ???? ?????? ???? ??? AV ???? ?????

152353 ????? #: WINDOWS: 15383 (6.00 ? 6.50)

????? ??? ????? ???? ????? ?? ???? ????? ??? ??? ?? ???? ????- ??? ?? ???? IN ?????? ?????? ??? ?????? (AV) ????? ???? ?? ??????? ???.

????? ?????? ?? ??????? View definition:
   create view MyView as
   Select   Column1, Column2=
         Case
           When SomeColumn In
            (Select  SomeOtherColumn
              From   SomeOtherTable)
             Then SomeValue
           Else Null
         End
   From  MyTable
				

?? ???? ????? ?? MyView ?????? ?????? ??? ??????.

???? ?????? sp_processmail ??????? ?????? ??? ??????????? ??????? ??? ?????? ?? ?? ??? ??? ?????? ?? ???? ????? SQLMail ?? ?????? ???? Microsoft Exchange ???.

?? ???? ???? ????? ??? ??????? ?? ????? SELECT AV ??????? ??? ??????? ??????.

perceives ?????? ?????? ????? ?????? ???? ??? ????. ????? ???? ??? ???? ?????? ?? ????????? SELECT ????? ?? ???? GROUP BY ?? ORDER ??????? ??????.

?? ?? ???? Count(*) ?????? ?????. ???? ??? ??????? ??? ????? ??? 34 ?? ???? ?? ???????. ??? ????? ??????? ?? ???? ??????? ???????:
?? ??? ??? ????? ?????? ???????? ? ?? ??? ?????? ?? ????

??? ?????? ????? ????? ?? ?????? ?? SELECT INTO ?? ??? ?????? ??? ???? ???.

??? ????? ?? ????? ??? ???? ????? ??? ????? ??? ??? * ?? ????? ??? ???? ?? ?? ???? ?????. ?? ???? ????? ????? ????? ???????? ??? ???? ????? ??? ????? 34 ?? ????.

???? ????? ???????? BLOB ?????? ????? SQL Server 2.65.0201 ?????? ?? ??? ?? ???? ????. ??? ????? ????? ????? ??? ?????? ????? ???? ???? ?????? ????? SQL ??? ???? ???? ???? ???? ????? ?? ???? ??????. ???? ??? ????? ????? ???????? BLOB ???? (???? ?? 64 ???? ????).
??? ???? ?????? ???? ?? ???????
???? ???? ??? ???? ?????? ?? ?????? ???????? '?????'.
??????: 37000 "?" ????: 156 "?" ????: ???? SQL ODBC [[Microsoft]
?????? ???????] [SQL Server]

??? 1 "???? ???? ??? ???? ?????? ?? '='
??? ??????: 37000 ? ????: 170: ???? SQL ODBC [[Microsoft]
?????? ???????] [SQL Server]

??? ??? ????? ??????? SQL ???????? GROUP BY ?? ??? ????? ???? ??? ?????? ??????? ?? GROUP ????????? ????? ?????? ?? s/????? [ASCII 146] ???? ?? ??????? ? esulting ?? ??? ?? ??????. ???? ??? ??????? ??? ??? ?????? ??????? Alpha ???.

?? ???? ?????? ??? ????? ?? ????? ?? ????? ??????? ????? 3201 tbswritecheck ?? ?????? ??? ?????? (AVs). ??? ?????? msg 3201 ???????? tbswritecheck ??? ?????? ?????; AV ?? ???? ????? ???????.

??? ????? ????? ???? ???? ???? ??????? ??? ?????? ???????? - ????? ??? ????? ?????? (DBLIB ?? ODBC) ??? ???????? ?? ??????? ???????? ? SQL Server ????? ?????. ????? ???? SQL ????? ??? ??????.

???? ?????? ????? ????? ??? ???????? ????? SQL Server ?????? ???????.

?? ???? ??????? ?????? ??????? ?????? ?? ????? ???????? ?? SQL Server 6.50 ??????? "????? ???? ????? ???" ?????? Logreader ??? ???????? ????? ?????? ??????? ???????:
??? ?? ?????? .Possible ConnectionTransact (GetOverLappedResult()):
??????? ??? ???? SQL. ???. ??????? ?????.

???? ??? ????? logreader ?? ?????? ????????? ????? ????? ???????? ???? ????. ????? ??? ??????? ??? ????? ?????? ???? ?? ?????? ?? ???? ?????. ??? ??? ???? ??? ?????? ?? SQL Server ????? 6.50.

????? ?????? "??? ?????? ????" ?? ????? FROM ???????? SELECT ???? ?? ????? ??? SQL Server 803. ??? ???? ??????? ????????? ??????:
   select authors.au_id
   from
   (((( authors
   left outer join titleauthor on authors.au_id=titleauthor.au_id)
   left outer join titles on titleauthor.title_id=titles.title_id)
   left outer join authors a1 on a1.au_id=titleauthor.au_id)
   left outer join roysched on titles.title_id=roysched.title_id)
   where (roysched.royalty = 20)
				

????? ??? SQL Server ???????:
????? msg 803 ????? 20? 2
??? ???? ??? ??? ?????? ?????? 0x0 ????? 424 sdes ?? ?????? ???????? ?????
'titleauthor' - ??? ???? ?? ???? ????? ?? sdes ?? ???? ?????? ??
???? ????????.
SQL ??? ????? Server ??? ???????.

???? ??????

??????? DBPROCESS ?????? ?? ??? ?? ???? ?????.

FIX: ??? SQLNumResultCols ?? ???? ???? ??? ???? ?????? 'SET'

153694 ????? #: NT: 15314 (6.50)

???? ????? ????????? ??????? ?? ??????? ??? ??? ???? SQL.

FIX: ????? ????? 16 ?? ??? ??????? ??? ??????? SQLTables ??????

153908 ????? #: NT: 15563 (2.65.0201)

?????? ??? ??? ???????? ?? ??????? ?????? ????? ODBC ?? ??? ??? ??????. ???? ????? ??? ?? ??????? ?????? ?? ????? ??? ???:
  • ??????? ODBC ????? ?????? ??? ODBC API ??????? SQLSetStmtOption() ?? SQL_ASYNC_ENABLE (????? ??? SQL_ASYNC_ENABLE_OFF).
  • 3.0 Visual Basic ???????? Access 2.0 ????? DisableAsync ??? 1 ?? ?????? [ODBC] ?? Vb.ini App.ini ?? Msacc20.ini ??? ???????.
  • 4.0 Visual Basic ?????? ????? INIPATH DBENGINE ??????? ??? Vb.ini ?? App.ini ?? DisableAsync ??????? ??? 1.
?????? ??? ??????? ??????? MSACC20.INI ??????? ??? Access 95, ?????? ?????? ??????? ??????? ?? "????? ??????? ?? Microsoft:
139044: INF: ????? ????? ???? ODBC MSACC20.INI ??????? ??? ???????

???? ??????? ??????? 3.x (???? ????? ?? Access 95 ? 4.0 Visual Basic) Jet ??? C ?????? s ????????? ???? ????? ?????? Jet Microsoft [ASCII 146] ????. ????? ?????? ??? ??????? ???? ????? ?????? 2.x Jet ?? 1 ????? ????? ?????? ?????? Microsoft ?? ???? ????????? ?? ???????:
????? ???? ????? ???????? Jet ?????? neil

????? ????? ?????? Backgrounder ?????? ???? "Jet Engine ODBC ????? ????? ????????."

????? ??? INSERT ?? ????? INSERT ????? ??? ???? ?? UNION. ??? ??? ???? INDEX ???? ?? ?????? ????? ?????? ?????? IGNORE_DUP_KEY ??? ??? INDEX ?????? ?????? ??????? ?????? ?? ?? ????? ?????? UNION. ?? ???? ?? ???????? ??? ??????? ???? ?? ???? ???? ????? ??? ??? ???? ??? ???? ???? ????? ???? ????? intermedate ???? ?? ????.

FIX: ?? ????? ????? TABLE ?????? ??? 3301 AV

149939 ????? #: NT: 14849 (6.50)
?? ???? ??? ????? ???? ?????? ????? TABLE ??????? ??????? DELETE ?? ?? ???? WHERE. ??? ??? ????? ????? ????? ????? ???? IDENTITY ??????? DELETE ?? ?? WHERE ???? ?? ??????? TABLE ? ???? ?? ???? ?? ?????? ??????? ?? ??? ???????? ?? ??? TABLE ??????? ??? ???? ???
delete t1
while @@trancount > 0
begin
   commit tran
end
truncate table t1
				

FIX: CREATE TABLE ?? ????? ???? ?? ??? ?? ????? 1750

150775 ????? #: NT: 14884 (6.50)

??????? ?????? ???? ?? CONSTRAINT ISNULL ? ?????? ??? ????? ?????????? ???? ?????? ?? ??????.

FIX: ?????? ??? TRAN ??????? ?? AV ???????

150894 ????? #: 14952 (6.50)

????? ????? ???????? ?? re-sync ????? ????????.

FIX: ????? SH_PAGE ?? ???? ??????? ??? ????? ???????? ?? ??????

150896 ????? #: NT: 15329 (6.50)

??????? ????? ??? ???? ????? ?? ?????.

FIX: ?????? ??? TRAN ??????? ?? ????? 1511

150897 ????? #: NT: 15114 (6.50)


????? ????? ?????? ??????? ??? CREATE ??????? ???????? INDEX ??? ???? ????.

FIX: ?????? ??? UPDATE ?? ????? 107

150900 ????? #: NT: 14984 (6.50)

????? ????? ????? ???? 204 ?? ????? ????? JOIN ?? ??????? ????.

FIX: ???? ?????? ?????? ??? ?????? ?????? ?? FOR ????? UPDATE AV

151111 ????? #: NT: 15086 (6.00)

?? ?????? FOR ?? ???? UPDATE ????? ???? ?? ???? ?? ???? ?? ???? ????. ??????? ???? ???? ??? ??? ???? ???? ?? ???? ??????? ?? ???? FOR UPDATE.

FIX: ??? 4409 ?????? ??? ??????? ??? ??? ?????? ?? ????? ????????

151590 ????? #: NT: 14645 (6.00)

????? ?????? ??? ????? ??? ?????? ?? ?? ??? ?? ?????? ?????.

FIX: Checkident DBCC ????? ?????? ???? ??? ?? ??????

151591 ????? #: 14759 (6.50)

??????? ??? ???? ?????? ??? ????? ?? ???? ?? ?????? ???????? ?????? ?????????? ??? ????? ??????. ?????? ?? ???? ??????? ??? ?? ????? ???? ?? ???? ?????? ??? ?????? ??????? ?? ??? ???????? ?? ????? ?????.

?? ???? ??? ????? ???? ?????? ??? ????? ??????? ??? ??? ???? ?? ???? ?????? ?????? ??? ????? ???? ?? ???? ??????. ???? ?? ????? ????? ???? ???? ??? ????????? ????? ?? ????? ??? ????? ??? ???? ?? ???? ???? ???? ?????.

FIX: SELECT INTO ???? ???? ????? ????? Temp ?????

151765 ????? #: NT: 15113 (6.50)

??????? ????? ???? ???? ????? ?? ??????? ?????? ??????. ?????? ODBC ?? ?????? ????? ???? ???????? "????? ??????? ?????" ???? ???????? ?????? "????? ??????" ?? ???? ?????? ????? ?????? ????? ODBC SQL Server ?? ?????? SQL_USE_PROCEDURE_FOR_PREPARE ???? ?? ???? SQLSetConnectOption ??? SQL_UP_OFF.

???? ???? ?????? ???? ???? "????? ????? ?????" ?? ????? ??? pre-processing ???? ???? ??? "????? ????? ?????" ???????? ???? IF ??? ?????? ??????? ?? ?? ?????? ????? ??? ??? "???? ???????".

FIX: "???? ??? ?????? ???? ?????????" ?? ????? sp_processmail

??? 152416 #: 15475

??? ??? ????? sp_processmail ????? ? ???? ???????? ???????:
  1. ????? ???? ????? ?? ?????. ???? ?? ??? ??? ???? ????? ?? ???? ??????? ???? ?? ???? ?? ??????? ?????? ??? SQL Server ??? ?????? ??????????.
  2. ??? ??? ???? ??? sp_processmail ??????? ????? ?? ?????. ??? ???? ???? ?????? 1 ?????.
  3. ????? ??????? sp_processmail ????? ?? ???? ?????? ???? ?????? ???? ??????? ??????? xp_deletemail.
  4. ????? ??????? sp_processmail ????? ??? ????? ?? ???? ???? ????? ?? ??? ??? ???? ???????.

FIX: ?? ????? ??? ?? ???? ???? ?? ????? SELECT ?????? AV

??? 152615 #: 15027 (6.0)
????? ??????? ????? SELECT.

FIX: Count(*) ?? ??? ????? ?????? ???????

??? 152690 #: 15418 (6.5)
???? ??????? ????????? ?????? ????? ?? Count(*) ??? ??????
   select rows from sysindexes where name like 'My_Table_name'
				

?? ?????? SELECT INTO ?? ?????? ?????? ??? ?????? ??????) ? ????? ???? ?????? ?? ????? ????????? ??????:
   insert Destination_Table select * from Source_Table
				

FIX: ????? ????? ???? 2.65.0201 ????? ???????? BLOB w/SQL

152709
??? ??????? ?? ????? GROUP BY. ???? ????? ????? ???? ???? ??????? ??????? GROUP BY ???? ????? ?? ?????? ???????? ??? ????? ??????? ?? ?????????.

FIX: ????? ?? ????? w/???? ????? ??????? ?? ????? AVs

153006 ????? #: NT: 15499 (6.50)
?? ????? ??? ???? ????; ????? ?????? ???????? ??? ??? ?? ???? ??????? ??? ?????. ??? ????? ??? ????? "? ?????? ???? ????? ????????? ???? ??? Windows NT Backup ????? ??? ????? ??? ??????.

?????? ????? ???? ????? ????? ?? ????? ???? ???? ???? ??????.

????? ????? ????? ?? ??????? ???????? ??? ?? ???? ?????? ???????.

????? ??????? ???? ???? ????????:
  • ??? ?????? ?????? ????? ?? ??????? ??????? ??????.

    -??-
  • ????? ???? ????? ???????? ???????? ?? ????? ?????? ???? ??????? siphoned (???????? ?????? ?? ??? ?????) ??? ?? ??? ?????? ??????.

FIX: ????? "LEFT JOIN OUTER" ?? FROM ????? ?? ????? ???

153455 ????? #: NT: 15565 (6.50)

?? ????? ???????? ???????? ?? ?? ???? ???????? ?? ????? ????????, ?????? ??????? ??????? sp_droppublisher ?????? ????? ???????? ????? ??????:
use master
go
if exists (select * from sysobjects where sysstat & 0xf = 4 and name =
'sp_droppublisher')
   drop procedure sp_droppublisher
go
create procedure sp_droppublisher (
   @publisher varchar (30),        /* publisher server name */ 
   @type varchar (5) = null     /* null or 'dist' */ 
        ) as
    declare @distaccount varchar(127)
    declare @proc varchar (255)
    declare @retcode int
    declare @privilege varchar (30)

    /*
    ** parameter check:  @publisher.
    ** check to make sure that the publisher exists, that the name isn't
    ** null, and that the name conforms to the rules for identifiers.
    */ 

    if @publisher is null
        begin
            raiserror (14043, 16, -1, 'the publisher')
            return (1)
        end

    execute @retcode = sp_validname @publisher

    if @retcode <> 0
   return (1)

    /*
    ** perform special logic if dropping a publisher for a distribution
    ** server.
    */ 
    if lower(@type) = 'dist'
      begin
       if not exists (select *
      from master..sysservers
                where srvname = @publisher
                and srvstatus & 16 <> 0)
       begin
      raiserror (14080, 11, -1)
           return (1)
       end

       execute @retcode = sp_serveroption @publisher, 'dpub', false
       if @@error <> 0 or @retcode <> 0 return (1)

            if exists (select * from master..sysremotelogins
          where remoteserverid = (select srvid from master..sysservers
          where srvname = @publisher)
          and remoteusername = 'sa'
          and suid = 1)    /* 'sa' */ 
       begin
          execute @retcode = sp_dropremotelogin @publisher, sa, sa
          if @@error <> 0 or @retcode <> 0 return (1)
       end
            if exists (select * from master..sysremotelogins
          where remoteserverid = (select srvid from master..sysservers
          where srvname = @publisher)
          and remoteusername = 'probe'
          and suid = 10)   /* 'probe' */ 
       begin
          execute @retcode = sp_dropremotelogin @publisher, probe, probe
          if @@error <> 0 or @retcode <> 0 return (1)
       end

       return (0)
   end

    /*
    ** make sure the server is defined as a 'publisher'.
    */ 
    if not exists (select *
                     from master..sysservers
                    where srvname = @publisher
                      and srvstatus & 2 <> 0)
        begin
            raiserror (14080, 11, -1)
            return (1)
        end

    /*
    ** turn off the server option to indicate that this is a publisher.
    */ 
    execute @retcode = sp_serveroption @publisher, 'pub', false
    if @@error <> 0 or @retcode <> 0 return (1)

    /*
    ** fetch the publisher's distributor account.
    */ 

    select @proc = rtrim(@publisher) + '.master..sp_helpdistributor '
    exec @retcode = @proc @account = @distaccount output
    if @@error <> 0 or @retcode <> 0
        begin
            raiserror (14071, 16, -1)
            return (1)
        end

    /*
    ** if @distaccount = 'localsystem' assume 'admin' privilege
    */ 
    if @distaccount = 'localsystem'
       return (0)

    /*
    ** if @distaccount has 'admin' privilege, do not revoke
    */ 
    execute @retcode = master.dbo.xp_logininfo @distaccount, 'all',
       @privilege = @privilege output
    if @@error <> 0 or @retcode <> 0 return (1)

    if @privilege = 'admin'
       return  (0)
 
    /*
    ** revoke replication privilege to the distributor nt account.
    */ 
    exec @retcode = master.dbo.xp_revokelogin @distaccount
    if @@error <> 0 or @retcode <> 0 return (1)
go
				

???? ??????? ??? ????? ??????? ????? ????? ?????? 'pub' ???? ?????? ?????? ????? ??????? ??????? ??? ???? ????????:
use master
go
sp_serveroption <publication server>,  'pub', false
go
				

??? ???? ??????:
use master
go
sp_serveroption AIKMAN, 'pub', false
go
				

??????? ????

????? ???? ?????? ????? SQL Server ODBC ?????? T-SQL ??????? ???? ???? ??????? ??? ?????? ??? ??? ??????? ???? ???? ????? ?? resultset ? ???? ???? ??? ???? ???? ????????? ?????? ??????? ??? ?????? ???????. ??? ???? ??????:
   SQLPrepare(hstmt, "SELECT t1.c1, (SELECT t2.c1 FROM t2) FROM t1", 44)
   SQLNumResultCols(hstmt, pcol1)
				

???? ?? ??? ??????? ??????? ???? ??? ??????? ??? ?????? ??? ??????? SQLNumResultCols:
   SET FMTONLY ON SELECT t1.c1, (SELECT t2.c1 FROM t2)
   FROM SET FMTONLY OFF
				

??? ?? ???? SQL Server ??????? ?? "???? ???? ??? ???? ?????? ?? ?????? ???????? 'SET'."

??? ????? ??????? ????? ?????? ????/???? Microsoft ? ??? Access 2.0 ? 3.0 Visual Basic ? 4.0 Visual Basic (16-??) ?? ???? ????? ?????? Jet. ????? ???????? ?????? ??????? ??? SQLTables() ????? ??? ?????? ODBC ???? ????? ????? ??? ???? SQL Server 6.5. ?????? ??? ????????? ODBC ?? ??? ??? ????????? ???? ???????. ??? ??? ?? ????? ????? ?????? ????????? ??? ?????? ??? ???? ????? ????? "?????? ????" ?? ????? ?????? ??????? 2.65.0201.

??????: Microsoft Excel ? Microsoft Query ?? ??? ????? ?? Jet ???? ????? ?????? ???????? ??????? ?? ????.

????? ?? ????????? ??? ???? ????? ?????? Jet ?????? ?????? ??? ???? ????????? ???? ????? ?????? Microsoft Jet ????? ?????? Microsoft Press. ISBN ??? ?? 1-55615-877-7. ????? ????? ?????? ?? ???? ??????? RESS MSP (800).

FIX: ????? AV ??? INSERT ?? UNIONed ??? ???? ???????? ????????? ??????????

149938 BUG #: NT: 14833 (6.00 ? 6.50)

?? ?? ???? ?? ????????, ???? ??? ??? ?? ??? ????? ?? ?? UNION ???? ????. ??? ??? ?????? ????? ????????? ??? ?? ??? ??????? ??? ????? ????? ???????? ???? ???? ???? ?? ?????? ????? ??? ??? ?????, ??? ????? ?? ????? ??? ?? ????????? ??? ??? ?? ??? ?????? ??? ?? ??? ???? AV.

??? ??? ???? ??? ??????? ?? ????? ???? ??? CREATE TABLE ???? ?? ???? ??? ?????. ?? ???? ???? ???? ???? ????? ??????? ??????:
create proc sp_test1 as
begin
IF ( @@error <> 0 )
BEGIN
   GOTO cleanup
END
CREATE TABLE   #t1 (c1         int NOT NULL DEFAULT -1)
cleanup:
end
go
declare @rc int
EXEC @rc = sp_test1
SELECT @rc
go
				

?? ??? ????? ????? ?????? ??? ????/????? ??????? ?????? ??? ????? ???? ???? ????? ??? ??????? ???????? ??? ????? SELECT. ?????? ??? ?? ??? ??????? ???? ?? ??? ??????? ??? traversed ????? ?????? SQL Server ??? ??????? ?????. ?? ??? ???????? ????? ?????? ???? ??????. ??? ???? ??????? ???? ???? ?? ???? ????? ??????? ????. ?? ???? ??? ?? ????????? ??????? ?? SQL Server.

??? ?????? ??? ?????? ????? ?? Microsoft SQL Server 6.0.

?? ????? ODBC ??? ?????? ??? ?????? ???:
  1. ????? ??????? ????? ???????? ????? ?????? ?? ????? ???? ???????? ?? ???? ?????? ????? ?????? ????? ODBC SQL Server.
  2. ?? ????? ?????? SQL_USE_PROCEDURE_FOR_PREPARE ?? ???? SQLSetConnectOption SQL_UP_ON.

?? ????? ????? SELECT INTO ???????.

FIX: ???? ?? ????? SYSPROCESSES ?? ?????? ????


????? ???????: 151985 BUG #: NT: 15280 (6.00 ? 6.50)
??? ??? ???? 4030 ???? SQL ??? ??????? ?? 2.65.0201 ???? ?????? ????? ???? SQL ???? ?????? ?????? ??? ????? ????? ????? BLOB ????????:
   SELECT TEXTPTR(imagecol) FROM imagetest where intcol=update imagetest
   set imagecol=0x00
				

??? ???? ???? ??? ????.

?? ???? ??? ?? 2.50.0121 (????? ????? ??????? 6.0) ????? .They:
   SELECT TEXTPTR(imagecol) FROM imagetest where imagecol LIKE
   0x000000

   WRITETEXT BULK imagetest.imagecol 0xa
				

FIX: ???? ???? SQL ?? ????? ??????? ?? ?????????

??? 153079 # 15570 (6.50)

errorlog SQL Server (??? SQL...????? ?????? \LOG ??? ??????):
631 ???: ???????: ???? 21 ?: 1
??? 116 spid12 ????? ???? ????? ???? ?? ??
????? 32 ??? ????? ?? ?????? ???????: ???? ?????? = 0xa8b000 ?
pageno = 104 ?????? = 0x101 objectid = 6? indexid = 0
kernel ?????: ?????? ??? ????? ????? ????? ????? Dataserver
631 ???: ???????: ???? 21 ?: 1
??? 116 ????? ???? ????? ???? ?? ??? ??????? 32
??? ????? ?? ?????? ???????: ???? ?????? = 0xa8b000 pageno = 104 ?
?????? = 0x101 objectid = 6? indexid = 0
kernel udread: ???? ??????? ??? 6 (?????? ?? ????.) ??? ??????
'C:\SQL60\DATA\MASTER.DAT' (virtpage 0x000002fb).
????? ?????? ?????? d 8 8700 ?? ????? ???????? '?????' ??? ?????? 0 ?? ??? ??????
??????? ??? 759 ?? ??? ?????? ??????
??? ????? 822 ?? ex_print
kernel mirrorproc: ??? ?? ???????/??????? ??? ?????? ??????? 'C:\SQL60\DATA\MASTER.DAT'

FIX: ?? ???? ?????? ????????? ???????? ??????? ????? ??????

153186 ????? #: NT: 15451 (6.50)

FIX: Deadlock ????? ???? ?????? CPU ????? ??????? ? Spinloop

153802 ????? #: 15422 (6.50)

???????

???? ?? ????? ?????? ?? ????????? ?? ???? ???????? ???? ???? ??? ?????? ??? ?????? ???? ???? ??? ????? ?????? ?? ??? ???????:

closetable: ???? ????? ?????? ?? ??? sdes %d

??? ???? ??? ?????? ???? ?? ???? ??????? unkillable ?? ?????? ?????? ?? ?? sysprocesses ?? ??? ????? ??? ??? "spinloop." ??? ??? ?????? ???? ???? ?? ?????? SQL Server ? ???? ?????? ????? ?? ????????? ???? ????, ??????? ?? ??? ????? ?????? ?? ????? ????? ???. ???? ??? ???????? ???? ?? ?????? ??? ???????.

???? ??????

??? ??????? ???? ?????? ?? ????????? ???? ?? ???? ??? ?? ???? ??? ???? ???? ???? ???.

FIX: ??? GRANT ALL ??? ?????? ??? ????????? ????????

153803 ????? #: 15102 (6.50)

???????

??? ?????? ?????? GRANT ALL ????? ???? ? ?? ???? ???????? ????????. ??? ??????? ?? ?? ?????; SQL Server ?????? ?? ???? ????? ??? ??????? ??????. ????? ???? ????? ???? ???? ????? ????? ?? GRANT ALL ????? ????? ??? ??????? ??????.

???? ??????

???? ?????? ??? ????? ???? ?????? ??? EXEC ????? ?? ??? ALL.

FIX: ??? SQLGetData ??? ??????? ?????? ???? ??????

153836 ????? #: 15053 (6.50)

???????

?? ???? ????? ????? ????? ????? ???? SQLGetData ??? ????? ?? ????? ????? ????? ?? ??? ?????. ??? ????? ????? ??????:

szErrorMsg = "[Microsoft] [ODBC SQL Server ?????? ???????] ??????? ?????? ????? hstmt ???"

???? ??????

??? ??????? ?????? ??????? ???????? SQLBindCol ??? ?????. ???? ??? ????? ????? ????? ??????.

???? ?? ?????????

??? ??????? ???? ?????? ????? ??? ???? ?? ???? ??????? ??? ?????? ??????? ????? ??? ????????. ????? ?? ?????? ???? ?????? ?????? ???? ?? ??? ?????. ??? ???? ?? 2.65.0121v ?????? ????? SQL Server ODBC ?????? ????? ???????? ???????? SQLGetData ??? ????? ????? ?????? ????. ?? ???? ????? SQLFetch ??? hstmt1 ???? ????? ??? ???? ??? ?? ??? ????? ???? SQL_NO_DATA_FOUND ????? hstmt2 ????? ??? ????? ????? ????? ??? ?? ?? ?????? SQLGetData ??????? ??? hstmt1 ???? ??????? ??? "????? ????? ??????".

FIX: AV ??? 4 ?? ???? Correlated ??????????? ??????? ?? Self-Join

153851 ????? #: 14802 (6.50)

???????

??? ??????? ???? ??? ??? ????? ?? ??????????? ??????? ????? ?? ???? ?? ???? ?????? ??? ??? ?????? ???? ?? ???? ??? ??? ???? ????? ???? ??????? (AV) ??? ??? ?????? ????? ??? ??? ??? ??????? ???????? ????.

???? ??????

????? ?????? ??? ?????? ??? ???? ?????? ???????? ?? ??????.

FIX: ???? IRL 3307 ??? OS 6? unhandled ????? ?????? AV

153855 ????? #: NT: 15569 (6.50)

???????

??? ?? ????? ???? ?????? ????? - ??? ?? ????? (IRL) ?? "sp_tableoption 'table_name' '????? ????? ????' ? true" ???? ?????? ????????? ?????? ???????? '???????? tran' ?? '????????? tran' ??? ????? ?? ???? ??? 3307 "Process % ld ??????? ???????? ????? ?????? ??? ?????? % ld." ? ????? OS 6? 602 "???? ?????? ??? ???? ?? Sysindexes ?? dbid '% d' ' ?? ' ?????? '% ????' ' ?? ' ???? '% d'." ? ???? ?????? ???? ????? ???? ??? ????? (AV).

???? ?? ?????????

??? ??????? ????? ???? ?????? ???? ???????? ??? '???????? tran' ? ???? ????? ????? ?????? ?? errorlog:
3307 ???: ???????: ???? 21 ?: 1
??? ?? ??????? ???? ????? 10 ???????? ????? ?????? ??? ?????? 336.
?????: ?????? ??? ????? ????? ????? ????? Dataserver
udread: ???? ??????? ??? 6 (?????? ?? ????.) ??? ??????
'C:\MSSQL\DATA\MASTER.DAT' (virtpage 0x000009a4).
udread: ???? ??????? ??? 6 (?????? ?? ????.) ??? ??????
'C:\MSSQL\DATA\MASTER.DAT' (virtpage 0x00000394).
udread: ???? ??????? ??? 6 (?????? ?? ????.) ??? ??????
'C:\MSSQL\DATA\MASTER.DAT' (virtpage 0x00000383).
????? ?????? ?????? 8d3b20 ?? ????? ???????? '?????' ??? ?????? 0 ?? ??? ??????
??????? ??? 895 ?? ??? ?????? ??????
??? ????? 822 ?? ex_print
mirrorproc: / ????? ??? ??? ?????? ??????? 'C:\MSSQL\DATA\MASTER.DAT'

SQL Server ???? ????? ???? ???? ???. ??? ????? ????? SQL Server ??????? CHECKDB("pubs") DBCC ??????? ????? ??? 602 ???????: ?? ?? ?????? ???? ?? Sysindexes dbid '% d' ??? ?????? '% ????' ? ?????? '% d'.

??? ????? ?????? ??? ???? ??????? ????? ????????? ? sp_who ???? spid ?? ??? ?????? ???? ?????? 'spinloop' ? ???? ?? ???? ?? ????? ?? spid. CHECKDB DBCC ?? ????????? ???? ??? ??? ????? ?? ???? ????? ??????. ????? ????? ???? ?????? ?? ??????? bufwait() ?? errorlog. ????? ????? SQL Server ??? ????? AV ?? ????? SQl Server ?? ?????????.

FIX: ????? Deadlock ?????? ???? ????? ?? ????? 603 ? 3314

153954 ????? #: NT: 15307 (6.50)

???????

????? ???? ?????? ????????? ???????:
  1. ????? ???? ????
  2. ????? ???????? ?? ??????
  3. ????? ??? ???? ?????? ??????? ??? ?? ??? ????????? ?????? ??????? ?????? ??????
  4. ???? ??????
  5. ???? ???? ????
? ??? ??? ??? ?????? ?? ??? ??? ???????? ???? ???? ????? ?????? ???? ?? ??????? ?? ?????? ???? ???? ??? (spid 3). ?? ??? ??????? ??? ???? ????? ??????? ??? ???? ????:

????? "??????" (????? ??????? 3) ?? deadlocked ?? ????? ???? ?? ?? ?????? ?????? ???? ???? ???. ????? ????? ?????.

??? ?? ???? ??????? ??????? ???????:
603: ?? ???? ?????? ???? ??????? ??? ????????? ?????? ???? ???? ?????. ???? ?????? ???????? ??? ????? % d. ?????? ??????? ??????.

3314: ??? ??? ????? ??????? ?? ?? ??? ?? ????? ???????? ' %. * s '. % S_RID.

???? ????? ??? "?????? ????" ????? ???? ???????.

??? ????? sp_who ??? ??? ???? ????? 1105 ?? tempdb "?????? ???? ?????" ??? ????? ?? ??? ???????? ?????? ?????????? ?????? ??????? ?? ?? tempdb ?????? ????? ???? ?? ??? ?????? ?????.

FIX: ??? ??????? ' ? ' ?????? ????? AVs ? 707 ? 706 ?????

153961 ????? #: NT: 14828 (6.50)

???????

???? ????? ?????? ?????? ???? ?????? ???? ???? ?? ????? ???? ?????? ????? ??? ??????? ????? ???? SQL Server. ????? ???? ?? ??? 707:

??? ?? ?????? ???????? ????? ?????? ????? ??????? ??? ??????? 0 x % 1 x. ?????? ?????? SQL Server ??? ??????? ?????? ??? ???? ?? ????????.

?? ??? 706:
????? ??????? %d ????? PROC_HDR 0 x % lx ?? ???? ?? Pss.

???? ??? ?? ?????? ??? ?????? ??? ?????? ???????. ????? ???? ?? ???? ?????? ??? ?????? ??? ????? 707 ?? ???. ??? ??????? ??? ?????? SQL Server ??? ?????? ??? ????? ????? ??? ????? ????????? ????? ???????? ??? ????? ?? ????? CPU ????? 100 %.

???? ?? ?????????

????? ????? ????? ??????? ?????? ?? SQL Server ??????? ????? ???? ????? ???? ???? ???? ??? ???? ????? ????? ??????? ?????. ???? ?? ???? ??? ??? ???? ???? ??????? ???????? ??? ?????? ??? ??????. ???? ??? ??? ??? ??? ?????? ??????? ?????? ?????? ???? ????.

???? ??????

????? ????? ????? ??????? ?????? ??????? ???????? ??? ???? SQL ??? ????? ???? ???? ???????. ???? ????? ??? ?? ???? ????? ?????? ?? ??????? ???????? SQL Server ?? ?? ???? ????? ????? ??????? ?????? ??????? ???????? sp_configure.

FIX: ??? AV ??????? ???? Temp ??? ?????? ?? ????? ????

153987 ????? #: NT: 15510 (6.50)

???????

????? ????? ???? ???? ???? ?????? ????? ?? ???? ?? ???? ???? ?? ?????? ???????? ??? ???? ??????? ?? ????? ????? ???????:
msg 208 "??? Invalidobject # temptable"

??? ???? ??????? ??? ??? ????? ????? SQL Server ?????? ?????? ??? ??????? ?????? ??????? ??????. ??? ??? ??????? ?????? ??? ????? ?? ????? ?????? ? ???? ??? ???? ??? ??? ????? ????? SQL Server ?????? ??????.

???? ??????

????? ??? ??????? ??? ??? ??? ?? ?? ???? ???? ? ?????? ?????? ????? ???? ????? ????. ????? ???? ???? ???? ??????? ?????? ???? ??????? ?????? ????? ???? ????. ???? ?? ???? ?? ????? ???? ???? ??? ???? ?????.

FIX: ?? ???? ????? ????? ???? ?? ????? ??? ?????? ????????

153992 ????? #: NT: 15100 (6.50)

???????

??? ????? ????? ????? ???? ???? ??? ??????? ??? ???? ????? ??? ?????? ???????? ???? sp_rename ??? ???? ??? ?? ??? ?????? ??? ????. ??????? ??? folows:
msg 15006 ????? ?????? 16? 1
'< ??? ?????? >' ??? ??? ???? ??? ????? ??? ???? ??? ?????

msg 15224 ? ????? 11? ???? 1
???? ???? ????? NewName ????? ??? ???? ??? ????? ??
????? ???? ????????

???? ??????

????? ????????. ????? ?? ????? ????? ???? ???????? ?????? ?????? ??? ????? ????????. ????????? ??? ???? ????????.

FIX: AV ?? ??? ????? ????? ??? ????? ??????? ?????? ?????

??? 154018 #: 14827 (6.50)

???????

???? ?????? ??? ??????? ?? ??????? ?????? ??????? ?????? ??????? ?????? 323 ?????? ?? ??? ??? IN UPDATE ???? ????. ??? ????? ?????? ??? ??? ?????? ???? ??? ???? ??????? (AV).

???? ??????

????? ??? ???????? ?? ?????? ????? ???? 323. ???? ????? ???? ???? ????? ???????? ????? ?????.

????? SQL FIX: ??? ????? Self-References ???? ?? 15

154047 ????? #: NT: 15629 (6.50)

???????

?????? ??? ???? ???? ????? ??? 15 self-references ???? ?????? ?????? ??????? ?????????? ???????:
1202 ???: ???????: ???? 20 ?: 2
?? ??????? Table_lock ?? ????? ??? ??????? 0.

?????: ?????? ??? ????? ????? ????? ????? Dataserver

udwritem: ???? ??????? ??? 6 (?????? ?? ????.) ??? ??????
'C:\MSSQL\DATA\MASTER.DAT' (virtpage 0x00002739).

udread: ???? ??????? ??? 6 (?????? ?? ????.) ??? ??????
'C:\MSSQL\DATA\MASTER.DAT' (virtpage 0x00000394).

5157 ???: ???????: ???? 20 ?: 0
??? ????? 1202 ?? ex_print

???? ??? ??????? ????? ?? ??????? ?? ??? ??????? ???? ????? ????? ??????.

???? ??????

???? ???? ??????? ???? ??? ???? ?? 14 ????? ?????? ??? ????. ????? ???? ??? ???? ?? ????? ??? ????? ?????? ??????.

???? ?? ?????????

???? ??? ??????? ???? 15 self-references ??? ?? ??? ???? ??????.

??????: ??? ?? ????? ???? ????? ???????? ???? ????? ?????? ??? ????? (??? ??? Dr. Watson).

FIX: SELECT INTO ???? ?????

153441 ????? #: 14818 (DCR 6.50)

????

?? SQL Server 6.5 SELECT INTO ?????? ???? ??????. ???? ??????? ???? ?? ??????? ???????? SELECT INTO ??? ????? ???????? ACID (atomicity, ??????? ? ???, durability). ???? ???? ????? ??? ??? ???????? ????? ???? ??? ????? ?????? ???????? ? ???? ????? SELECT INTO. ?? ?????? ???? ???? ??? ???? ??? ??? ???? ??? ?????? ?? ?????? ????? ?????? ???????? ????? ????? ?????? SELECT INTO ??????. ??? ???? ??????? ??? ?????? ???? ???? ???? ??? ?????? ?? ?????????? ????? ???? ????? ??????? SQL ??????? ?????? ?????? ??? ????? ?????? ???? ???? ??? ??? ??? ???? ??????? SEM.

???? ?? ?????????

??? ??????? ??? SQL Server 6.5 Service Pack 1? SELECT INTO ?????? ??????? ????? ???? ?????? ??????? ????. ?????? SELECT INTO ?? ?????? ???? ?????? ?????????. ????? ?? ???????? ?????? ????? ?????? ??????? ??? ?????? ??????????? ??? ????? ????? ???? ?????? ??? ??? ????????. ?????? ????? ???? ??? ????? ?????? ??-T5302 ????? ??? ??????? ?? ?? ???? ???? "???????" ? ?????? ??????? ???????:
dbcc traceon (3604)
go
dbcc traceon (5302)
go
				

??? ????? ????? ???? 5302 SELECT INTO ??? ?? ???? ??? ????? ??????. ???? ????? ?????? ????? ????? ??????? ????? ????? ?????? ??? ??????.

???????

???? ???????: 153096 - ????? ??? ??????: 15/???/1427 - ??????: 5.0
????? ???
  • Microsoft SQL Server 6.5 Service Pack 1
????? ??????: 
kbmt kbfix KB153096 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????153096
????? ??????? ?? ????? ???? ?? ????? ???????
?? ????? ????? ?????? ???? ???? ???? ??? ??????? ??? ?? ? ?? ??? ??????? Microsoft ??? ????? ??? ??????? ????? ?????? ?????

????? ???????

 

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