FIX: ?? ???? ??? 1203 ??? ????? ????? INSERT ????? ???? ????? ???? ????? ?? SQL Server 2005

?????? ????????? ?????? ?????????
???? ???????: 933265 - ??? ???????? ???? ????? ????? ??? ???????.
???: # 50000793 (??????? ?????? SQL)
Microsoft ?????? ????????? Microsoft SQL Server 2005 ???? ???? ??????? ???????. ??? ????????? ???????? ????? ?? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2005 ??????? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ??????? ??? ??? ??????? ??? ??????? ??????:
  • ???????? ???? ??? ??????? ?? ???? ???? ????????? ???????
  • ????????? ??????? ?????? ???? ????????? ???????
  • ?? ??? ??? ??? ????? ????? ????????? ??? ????? ???? ????????? ???????
  • ?? ??? ??? ??? ??????? ???? ????????? ??????? ?????? ???? ????????? ??????? ??????
  • ?? ??? ??? ??? ????? ??? ??????? ???????
  • ??????? ??????? ?? ???? ????????? ???????

???????

???? ??? ????????? ??????. ???? ??? ????? ??????? ???? ????? ??? ???? ?? ???????. ???? ?????? ????? INSERT ???? ????? ??? ???? ????. ??? ??????? ????? INSERT ?? ??? ?????. ?? ??? ?????????? ?? ???? ????? ????? ???????:
??? 1203
???? ??????? %d ?????? ????? ????? ???? ?? ????: %. * ls. ????? ?????? ????????, ???? ?? ???? ??? ??? ????? ?? ???? ??? ?????. ??? ?????? ???????? ???? ?????? ????? ????????.

????

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

??? ??? ???????? ??? ?????? ??? ???? ??????? ???????? 2 ?? SQL Server 2005 ?????? ????? ?????? SP2 (???? 3175). ?????? ??? ???? ?? ????????? ??? ????? ?????? ??? ??????? ???????? ???? 2 (????? 3175) ? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft":
936305????? ???? ??????? ???????? 2 SQL Server 2005 ?????? ????? ?????? SP2

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

????? ????? ???? ????? ?? Microsoft. ???? ????? ??? ?? ?? ??????? ??????? ?? ??? ???????. ????? ??? ??????? ?????? ??? ??? ??????? ???? ????? ??? ??????? ????????. ?? ??? ????? ???????? ?????? ??? ??? ??????? ??????. ?????? ??? ?? ??? ????? ??? ??????? ??????? ???? ????????? ??? ??????? ?????? ?? ????? ???????? ???? ????? ??? ??? ??????? ??????.

?? ???? ????? ??????? ?????? ???? ??? "???? ????? ??????? ????" ???? ????? ????? ??????? ??? ???. ??? ?? ???? ??? ?????? ???? Microsoft ???? ??????? ?????? ?????? ??? ??????? ??????.

?????? ???? ?????? ?????? ?? ?? ?? ???? ?????? ??? ??????? ??????? ???????? ?? ???? ????? ????? ??? ???? ?????. ???? ????? ?????? ????? ???????? ??? ????? ????? ???????? ????????? ???? ?? ???? ??? ???? ??? ??????? ?????? ????????. ?????? ????? ????? ?????? ????? Microsoft ???? ??????? ?????? ?????? ????? ?? ?????? ??? ???? ????? ?? ?????? ???? Microsoft ?????? ??? ?????:
http://support.microsoft.com/contactus/?ws=support
?????? ???? ????? "???? ????? ??????? ??????" ?????? ???? ????? ??????? ??????. ??? ?? ????? ????? ?????? ??? ???? ??? ???? ?? ????? ????? ???? ???? ?????.

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

?????? ??? ??????? ??????? ??? ?? ???? ???? SQL Server 2005 ?????? ????? ?????? Service Pack 1 (SP1) ?????? ??? ???? ?????????. ?????? ??? ???? ?? ????????? ??? ????? ?????? ??? SQL Server 2005 ?????? ????? ?????? Service Pack 1 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
913089????? ?????? ??? ???? ???? ???? ?? SQL Server 2005

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

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

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

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

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

????? ??? ??????? ?????? ??? ??????? ???????? ?????? ???????? ???? ???? ??? ??????? ???. ?? ?? ????? ??? ??? ??????? ?????? ???? ??????? ???? ??? ?? ???? ???? ?????? ???? ????? ?????? ????? ????.????? ????? ????? ?????????? ?? ??? ??????? ?????? ???? ????? (?? ???? ????) ??????? ?? ?????? ??????. ??? ??? ???????? ???????? ?????? ???? ??????? ?? "??? ??????? ???????" (UTC). ????? ???? ???? ??????? ?????? ??? ??????? ??? ??????? ??????. ?????? ????? ??? ??????? ??????? (UTC) ???????? ??????? ?????? ????? ??????? ??????? ??????? ?? ???? ??????? ?????? ?? "???? ??????".
SQL Server 2005? x 86-based ?????????
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Bcp.exe2005.90.2227.069,48830 ???? ????20: 44x 86
Databasemailengine.dll9.0.2227.075,12030 ???? ????20: 44x 86
Logread.exe2005.90.2227.0400,75230 ???? ????20: 45x 86
Microsoft.analysisservices.adomdclient.dll9.0.2227.0546,16030 ???? ????20: 45x 86
Microsoft.analysisservices.deploymentengine.dll9.0.2227.0140,65630 ???? ????20: 45x 86
Microsoft.analysisservices.dll9.0.2227.01,217,90430 ???? ????20: 45x 86
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2227.078,19230 ???? ????20: 45x 86
Microsoft.sqlserver.sqlenum.dll9.0.2227.0910,70430 ???? ????20: 45x 86
Msasxpress.dll9.0.2227.024,94430 ???? ????20: 45x 86
Msgprox.dll2005.90.2227.0200,56030 ???? ????20: 45x 86
Msmdlocal.dll9.0.2227.015,646,06430 ???? ????20: 45x 86
Msmdredir.dll9.0.2227.03,993,96830 ???? ????20: 45x 86
Mssqlsystemresource.ldf??? ???? ???????524,28830 ???? ????14: 30??? ???? ???????
Mssqlsystemresource.mdf??? ???? ???????40,108,03230 ???? ????14: 30??? ???? ???????
Qrdrsvc.exe2005.90.2227.0369,52030 ???? ????20: 45x 86
Rdistcom.dll2005.90.2227.0643,44030 ???? ????20: 45x 86
Repldp.dll2005.90.2227.0187,24830 ???? ????20: 45x 86
Replmerg.exe2005.90.2227.0320,88030 ???? ????20: 45x 86
Replprov.dll2005.90.2227.0550,25630 ???? ????20: 45x 86
Replrec.dll2005.90.2227.0784,75230 ???? ????20: 45x 86
Replsub.dll2005.90.2227.0407,40830 ???? ????20: 45x 86
Spresolv.dll2005.90.2227.0177,00830 ???? ????20: 45x 86
Sqlaccess.dll2005.90.2227.0350,57630 ???? ????20: 45x 86
Sqlagent90.exe2005.90.2227.0321,39230 ???? ????20: 45x 86
Sqlservr.exe2005.90.2227.028,979,11230 ???? ????20: 45x 86
Sysdbupg.sql??? ???? ???????218,486?? ?????? ????13: 53??? ???? ???????
Xmlsub.dll2005.90.2227.0195,44030 ???? ????20: 45x 86
Xpstar90.dll2005.90.2227.0295,28030 ???? ????20: 45x 86
Xpstar90.rll2005.90.2227.0155,50430 ???? ????20: 45x 86
SQL Server 2005? x ????????? ???? ????? ??? 64
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Bcp.exe2005.90.2227.088,94430 ???? ??????: ??x 64
Databasemailengine.dll9.0.2227.075,12030 ???? ??????: ??x 86
Logread.exe2005.90.2227.0525,16830 ???? ??????: ??x 64
Microsoft.analysisservices.adomdclient.dll9.0.2227.0546,16030 ???? ??????: ??x 86
Microsoft.analysisservices.adomdclient.dll9.0.2227.0546,16030 ???? ????20: 45x 86
Microsoft.analysisservices.deploymentengine.dll9.0.2227.0140,65630 ???? ????20: 45x 86
Microsoft.analysisservices.dll9.0.2227.01,217,90430 ???? ????20: 45x 86
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2227.094,06430 ???? ??????: ??x 64
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2227.078,19230 ???? ????20: 45x 86
Microsoft.sqlserver.sqlenum.dll9.0.2227.0877,93630 ???? ??????: ??x 86
Msasxpress.dll9.0.2227.030,06430 ???? ??????: ??x 64
Msasxpress.dll9.0.2227.024,94430 ???? ????20: 45x 86
Msgprox.dll2005.90.2227.0262,00030 ???? ??????: ??x 64
Msmdlocal.dll9.0.2227.015,646,06430 ???? ????20: 45x 86
Msmdredir.dll9.0.2227.03,993,96830 ???? ????20: 45x 86
Mssqlsystemresource.ldf??? ???? ???????524,28830 ???? ????14: 30??? ???? ???????
Mssqlsystemresource.mdf??? ???? ???????40,108,03230 ???? ????14: 30??? ???? ???????
Qrdrsvc.exe2005.90.2227.0434,03230 ???? ??????: ??x 64
Rdistcom.dll2005.90.2227.0836,46430 ???? ??????: ??x 64
Repldp.dll2005.90.2227.0237,93630 ???? ??????: ??x 64
Repldp.dll2005.90.2227.0187,24830 ???? ????20: 45x 86
Replmerg.exe2005.90.2227.0417,64830 ???? ??????: ??x 64
Replprov.dll2005.90.2227.0747,88830 ???? ??????: ??x 64
Replrec.dll2005.90.2227.01,010,54430 ???? ??????: ??x 64
Replsub.dll2005.90.2227.0528,24030 ???? ??????: ??x 64
Spresolv.dll2005.90.2227.0225,64830 ???? ??????: ??x 64
Sqlaccess.dll2005.90.2227.0357,74430 ???? ??????: ??x 86
Sqlagent90.exe2005.90.2227.0392,56030 ???? ??????: ??x 64
Sqlservr.exe2005.90.2227.039,359,85630 ???? ??????: ??x 64
Sysdbupg.sql??? ???? ???????218,486?? ?????? ????13: 53??? ???? ???????
Xmlsub.dll2005.90.2227.0319,85630 ???? ??????: ??x 64
Xpstar90.dll2005.90.2227.0543,60030 ???? ??????: ??x 64
Xpstar90.rll2005.90.2227.0156,01630 ???? ??????: ??x 64
SQL Server 2005 ????????? ????? Itanium
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Bcp.exe2005.90.2227.0157,55230 ???? ??????: ??IA-64
Databasemailengine.dll9.0.2227.075,12030 ???? ??????: ??x 86
Logread.exe2005.90.2227.01,098,09630 ???? ??????: ??IA-64
Microsoft.analysisservices.adomdclient.dll9.0.2227.0546,16030 ???? ????20: 45x 86
Microsoft.analysisservices.adomdclient.dll9.0.2227.0546,16030 ???? ??????: ??x 86
Microsoft.analysisservices.deploymentengine.dll9.0.2227.0140,65630 ???? ????20: 45x 86
Microsoft.analysisservices.dll9.0.2227.01,217,90430 ???? ????20: 45x 86
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2227.078,19230 ???? ????20: 45x 86
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2227.0165,74430 ???? ??????: ??IA-64
Microsoft.sqlserver.sqlenum.dll9.0.2227.0877,93630 ???? ??????: ??x 86
Msasxpress.dll9.0.2227.024,94430 ???? ????20: 45x 86
Msasxpress.dll9.0.2227.057,71230 ???? ??????: ??IA-64
Msgprox.dll2005.90.2227.0545,13630 ???? ??????: ??IA-64
Msmdlocal.dll9.0.2227.048,718,70430 ???? ??????: ??IA-64
Msmdredir.dll9.0.2227.06,249,32830 ???? ??????: ??IA-64
Mssqlsystemresource.ldf??? ???? ???????524,28830 ???? ????14: 30??? ???? ???????
Mssqlsystemresource.mdf??? ???? ???????40,108,03230 ???? ????14: 30??? ???? ???????
Qrdrsvc.exe2005.90.2227.0943,98430 ???? ??????: ??IA-64
Rdistcom.dll2005.90.2227.01,884,01630 ???? ??????: ??IA-64
Repldp.dll2005.90.2227.0187,24830 ???? ????20: 45x 86
Repldp.dll2005.90.2227.0511,34430 ???? ??????: 03IA-64
Replmerg.exe2005.90.2227.0957,29630 ???? ??????: 03IA-64
Replprov.dll2005.90.2227.01,619,82430 ???? ??????: 03IA-64
Replrec.dll2005.90.2227.02,143,60030 ???? ??????: 03IA-64
Replsub.dll2005.90.2227.01,159,53630 ???? ??????: 03IA-64
Spresolv.dll2005.90.2227.0498,03230 ???? ??????: 03IA-64
Sqlaccess.dll2005.90.2227.0352,11230 ???? ??????: 03x 86
Sqlagent90.exe2005.90.2227.01,143,66430 ???? ??????: 03IA-64
Sqlservr.exe2005.90.2227.072,220,52830 ???? ??????: 03IA-64
Sysdbupg.sql??? ???? ???????218,486?? ?????? ????13: 53??? ???? ???????
Xmlsub.dll2005.90.2227.0593,26430 ???? ??????: 03IA-64
Xpstar90.dll2005.90.2227.0953,71230 ???? ??????: 03IA-64
Xpstar90.rll2005.90.2227.0154,99230 ???? ??????: 03IA-64

?????

???? Microsoft ?? ??? ????? ?? ?????? Microsoft ??????? ?? ??? "????? ???".

??????? ????

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

  1. ??? ????? SQL Server ????? Studio ?? ?? ?????? ??????? ????.
  2. ????? ???????? ??????? ?????? ???? ????????. dbo.User_Cost3 TABLE
    CREATE TABLE dbo.User_Cost3
    	(
    	Id int NOT NULL IDENTITY (1, 1),
    	Cost float(53) NOT NULL,
    	Started_Date datetime NULL,
    	Ended_Date datetime NULL,
    	User_Id int NOT NULL
    	)  ON [PRIMARY]
    go
    
    BEGIN TRANSACTION tran2
    declare @i int;
    set @i = 0;
    while(@i < 100000)
    begin
    	insert into dbo.User_Cost3 values(@i, GETDATE(), GETDATE(), @i)
    	set @i = @i + 1;
    end
    COMMIT TRANSACTION
    go
    
  3. ????? ???????? ???????.
    declare @i int
    set @i = 1
    while(@i > 0)
    begin
    
    BEGIN TRANSACTION tran1
    
    CREATE TABLE dbo.#Tmp_User_Cost2
    	(
    	Id int NOT NULL IDENTITY (1, 1),
    	Cost float(53) NOT NULL,
    	Started_Date datetime NULL,
    	Ended_Date datetime NULL,
    	User_Id int NOT NULL
    	)  ON [PRIMARY]
    
    ALTER TABLE [dbo].[#Tmp_User_Cost2] ADD CONSTRAINT [Tmp_IXPKCU_User_Cost2__Id] PRIMARY KEY CLUSTERED ([Id]) ON [PRIMARY]
    
    SET IDENTITY_INSERT dbo.#Tmp_User_Cost2 ON
    
    IF EXISTS(SELECT * FROM dbo.User_Cost3)
    	 EXEC('INSERT INTO dbo.#Tmp_User_Cost2 (Id, Cost, Started_Date, Ended_Date, User_Id)
    		SELECT CONVERT(int, Id), Cost, Started_Date, Ended_Date, CONVERT(int, User_Id) FROM dbo.User_Cost3 WITH (HOLDLOCK TABLOCKX);')
    
    drop table dbo.#Tmp_User_Cost2
    
    COMMIT TRANSACTION
    
    print 'ok'
    end
    go
????? ?? ????????? ??? ???? ??????? ???????? SQL Server "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
822499???? ????? ????? ??? ??????? ????? Microsoft SQL Server
????? ?? ????????? ??? ??????? ????? ??????? "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
824684??? ????????? ???????? ????????? ?? ??? ??????? ????? Microsoft

???????

???? ???????: 933265 - ????? ??? ??????: 10/?? ??????/1428 - ??????: 1.4
????? ???
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
????? ??????: 
kbmt kbautohotfix kbsql2005engine kbexpertiseadvanced kbfix kbpubtypekc kbqfe kbhotfixserver KB933265 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????933265

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

 

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