FIX: ???? ??????? ?????? ???? ??? ?????? ?? ???? ????? ???? ???????? ????? BLOB ???? ??????? ??????? ?? ???? ????? ?? Microsoft SQL Server 2008 ?? ?? Microsoft SQL Server 2008 R2

?????? ????????? ?????? ?????????
???? ???????: 2380435 - ??? ???????? ???? ????? ????? ??? ???????.
???? Microsoft Microsoft SQL Server 2008 ?????? Microsoft SQL Server 2008 R2 ???? ??????? ??????? ???????. ??? ???????? ?????????, ?? ????? ???? ????? ??? ???? ????????? ??????? ?????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ?? R2 2008 ???? SQL ??????? ???????.
????? ???? | ?? ????

?? ??? ??????

???????

???? ??? ????????? ??????:
  • ????? ????? ???? ?? Microsoft SQL Server 2008 ?? ?? Microsoft SQL Server 2008 R2.
  • ?????? ??????? ?????? ????? ???? ???? ????? (BLOB).
  • ??? ??????? ??????? BLOB ?? ???? ?????.
  • ????? ??????? ??????.
?? ??? ?????????? ??? ??????? ??????? ?????? ??? ??????.

????

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

SQL Server 2008 Service Pack 1

?? ????? ??????? ????? ???? ??????? ???? ??? ?? 10 ??????? ???????? ????? ?????? Service Pack 1 ?????? SQL Server 2008. ?????? ??? ???? ?? ????????? ??? ???? ??????? ???????? ???? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2279604???? ??????? ???????? 10 ? SQL Server 2008 Service Pack 1
????????? ??????? ???????? ????? ?? ????? ????? ???? ??? ???? ????????? ??????? ?????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ??????? ???????. ???? Microsoft ??????? ????? ????? ????? ?????? ???? ????? ??? ??? ??????? ??????. ?????? ??? ???? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
970365???? SQL Server 2008 ???? ?? ??????? ??? ????? SQL Server 2008 Service Pack 1
Microsoft SQL Server 2008 ????????? ??????? ??? ????? ??? ????? SQL Server ?????. ??? ????? ????? ???? SQL Server 2008 Service Pack 1 ??? ????? SQL Server 2008 Service Pack 1. ???? ???????? ??? ????? ?? ????????? ???????? ?? ???? ???? SQL Server ?? ???? ???? ? SQL Server ???????.

SQL Server 2008 Service Pack 2

?? ????? ??????? ????? ???? ??????? ????? ?? ??????? ???????? 1 ????? ?????? Service Pack 2 ?????? SQL Server 2008. ?????? ??? ???? ?? ????????? ??? ???? ??????? ???????? ???? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2289254??????? ???????? 1 ????? ?????? Service Pack 2 ?????? SQL Server 2008
????????? ??????? ???????? ????? ?? ????? ????? ???? ??? ???? ????????? ??????? ?????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ??????? ???????. ???? ??????? ????? ????? ????? ?????? ???? ????? ??? ??? ??????? ??????. ?????? ??? ???? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2402659???? SQL Server 2008 ???? ?? ??????? ??? ????? SQL Server 2008 Service Pack 2

SQL Server 2008 R2

?? ????? ??????? ????? ???? ??????? ???? ??? ?? 4 ??????? ????????. ?????? ??? ???? ?? ????????? ??? ????? ?????? ??? ???? ??????? ???????? ??? R2 2008 ???? SQL? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2345451???? ??????? ???????? 4 ? R2 2008 ???? SQL
????????? ??????? ???????? ????? ?? ????? ????? ???? ??? ???? ????????? ??????? ?????? ???? ??????? ?????? ???? ?? ??????? ?? R2 2008 ???? SQL ??????? ???????. ???? ??????? ????? ????? ????? ?????? ???? ????? ??? ??? ??????? ??????. ?????? ??? ???? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
981356???? R2 2008 ???? SQL ???? ?? ??????? ??? ????? R2 2008 ???? SQL

?????

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

??????? ????

?????? ????? ??? ???????? ???? ??????? ???????:
  1. ?? ?????? ????????? ???????? ??????? ?????? ????? ????????? ??????? ("p_test1" ? "p_test2"). ?????? "P_test1" ????? BLOB? ??????? "p_test2" ????? nvarchar(100).
    use tempdb
    go
    if OBJECT_ID('p_test1') is not null drop proc p_test1
    if OBJECT_ID('p_test2') is not null drop proc p_test2
    go
    create proc p_test1
    @s nvarchar(max)
    as
    begin
    select * from sys.objects 
    where name = UPPER(@s)
    end
    go
    create proc p_test2
    @s nvarchar(100)
    as
    begin
    select * from sys.objects 
    where name = UPPER(@s)
    end
    go
    
  2. ?? ?????? ???????? ???????? ??????? ??? ????? ??????? ?????? ?????? ?????? ??????? ????????? ???????:
    dbcc freeproccache
    go
    exec p_test1 N'abc'
    exec p_test2 N'abc'
    go
    
  3. ?? ?????? ????????? ???????? ??????? ?????? ?? ????? ??????? ??????:
    select object_name(CONVERT(int, a.value)), cp.*
    from sys.dm_exec_cached_plans cp
    cross apply sys.dm_exec_plan_attributes(cp.plan_handle) a
    where cp.objtype = 'Proc'
    and a.attribute = 'objectid'
    
    
????????? ??? ???? ?????? ?? executions ????????? ?? ??? ????? ?? ??????? ?????? ??? Microsoft SQL Server 2008 ?? ???? Microsoft SQL Server 2008 R2? ?? ????? ??? ???? ???? ?? ????? ??????? ??? ??????.

????? ?? ????????? ??? ??? ??? SQL Server ???? ????? ???????? ???? ????? "????? ??????? ? Microsoft" ???????:
263889??? ???? SQL Server ???? ????? ???????

?????

????? ?? ????????? ??? ????? ??????? (SQL ????????)? ?? ?????? ???? ??? Microsoft ???????:
????? ????? (SQL ????????)
?????? ??? ???? ?? ????????? ??? "????? ????? ??????" ? SQL Server? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
935897????? ????? ?????? ????? ?? ?????? SQL Server ?????? ????????? ??????? ??????? ???? ?? ??????? ????
?????? ??? ???? ?? ????????? ??? ?????? ??????? ??????? SQL Server? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
822499???? ????? ????? ???? ??????? ????? Microsoft SQL Server
?????? ??? ???? ?? ????????? ??? ??????? ????? ???????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
824684??? ????????? ???????? ????????? ?? ??? ??????? ????? Microsoft

???????

???? ???????: 2380435 - ????? ??? ??????: 09/?? ?????/1431 - ??????: 2.0
????? ???
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Standard Edition for Small Business
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Workgroup
????? ??????: 
kbqfe kbfix kbsurveynew kbexpertiseadvanced kbmt KB2380435 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????2380435

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

 

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