FIX: ????? ????? ??? ????? ??????? ????? ???? ????? ???? ???? ???????? ?? SQL Server 2005: "???? ????? Statement(s)" ? "????? ?????? '<column_prefix_name>' ??? ?????? ?? ??? ?????? ?? ??? ?????? ??? ???????? ?? ?????????"

?????? ????????? ?????? ?????????
???? ???????: 936223 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???: 50001186 (??????? ?????? SQL)
????? ???? | ?? ????

?? ??? ??????

???????

???? ??? ????????? ??????. ?? Microsoft SQL Server 2005 ????? ???? ????? ?????? ??????? SQL ?????? ???? ???? OLE DB (SQLNCLI). ????? ???? ????? ????? ??? Microsoft SQL Server 2000 ???????. ?? ??? ?????????? ????? ????? ????? ??????? ??? ????? ??????? ????? ???? ?????:
????? ????? 1
msg 8180 ? ????? 16 ???? 1? ????? ?????
?? ???? ????? statement(s).
????? ????? 2
msg 107 ? ????? 16 ???? 2? ????? ?????
????? ?????? ' <column_prefix_name> ' ??? ?????? ?? ??? ?????? ?? ??? ?????? ??? ???????? ?? ?????????.


?????? ???? ??? ??????? ????? ?? SQL Server 2008. ?? ???? ?????? ??? ??????? ??? ??????? ????? SQL Server 2000 ?? SQL Server 2008 ??? ????? ?????? ????? 4112 ??? ??? ???????. ????? ?? ?????????? ???? ??? "???? ?? ?????????".

?????

???? ??? ??????? ????? ??? SQL Server 2005 ?????? ???? ????? ????? ??? ??????? ?? ???. ??? ?? ???? SQL Server 2005 ????? ????????? ?????? ????? SQL Server 2000 ??????? ???????? ????????. ????? ??? SQL Server 2000 ?????? ????????? ??????. ?????? ???? ??? 107 ?? SQL Server 2000. ??? ???? ??? ??? ??? 107 ??? ???? ??? SQL Server 2005. ?????? ???? ??? 107 ?? SQL Server 2005 ????? ??? 8180 ?? SQL Server 2005.

????

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

?? ????? ??????? ????? ???? ??????? ???? ??? ?? ??????? ???????? 2. ????? ?? ????????? ??? ????? ?????? ??? ???? ??????? ???????? ??? ?? SQL Server 2005 ?????? ????? ?????? Service Pack 2 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft" (????? ?? ??? ???????? ??? ???? ?? ???? ??????? ??? ?? ??? ??? ?????? ??????????):
936305???? ??????? ???????? 2 SQL Server 2005 ?????? ????? ?????? Service Pack 2
?????? ??? ????????? ???????? ????? ?? ????? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2005 ??????? ???????. ???? Microsoft ?????? ????? ???? ????? ??????? ???? ????? ??? ??? ??????? ??????. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft" (????? ?? ??? ???????? ??? ???? ?? ???? ??????? ??? ?? ??? ??? ?????? ??????????):
937137???? SQL Server 2005 ???? ?? ??????? ??? ????? SQL Server 2005 ?????? ????? ?????? Service Pack 2
??? ????? Microsoft SQL Server 2005 ????????? ??????? ??? ???? SQL Server ?????. ??? ????? ??????? ???? SQL Server 2005 ?????? ????? ?????? Service Pack 2 ??? ????? SQL Server 2005 ?????? ????? ?????? Service Pack 2. ???? ???????? ??? ????? ????????? ??????? ???????? ?? ???? ???? ?? SQL Server ?? ???? ???? ?? SQL Server ???????.

???? ??????

??????? ?????? ??? ??? ??????? ?????? ???? Microsoft OLE DB ?? ODBC ????? ???? ????? ????? SQL Server 2000.

?????

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

??????? ????

???? ??????? ???????? (???? 3175) ?? SQL Server 2005 ?????? ????? ?????? SP2 ? SQL Server 2008 ?????? ????? ????? ???? 4112. ??? ????? ???? ??????? ???????? (???? 3175) ?? SQL Server 2005 ?????? ????? ?????? SP2 ??? ????? ?????? ????? 4112 ??? ??? ???????. ?????? ??? ??????? ??? ????? ????? ????? ???? ?? SQL Server 2005 ???? ?????? "???????" ?? ???? ???? ????? Microsoft (MSDN) ?????? ??? ?????:
http://msdn2.microsoft.com/en-us/library/ms188396.aspx

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

  1. ?? ?????? SQL Server ????? Studio ?? ?? ???????? ???? SQL Server 2005.
  2. ?? ?????? ??????? ???? ?? ?? ?????? ???????? ???????.
    EXEC sp_addlinkedserver
    @server = '<LinkedServerName>', 
    @provider = 'SQLNCLI', 
    @srvproduct = '', 
    @datasrc = '<InstanceName>', 
    @catalog = '<DatabaseName>' 
    
    exec sp_serveroption
    @server = '<LinkedServerName>' 
    ,@optname = 'RPC' 
    ,@optvalue = 'TRUE'
    exec sp_serveroption
    @server = '<LinkedServerName>' 
    ,@optname = 'RPC OUT' 
    ,@optvalue = 'TRUE'
    
    
    DECLARE @supervisorID varchar(40)
    set @supervisorID = 'Volume Discount'
    
    SELECT DISTINCT J.STOR_ID
    FROM   [<LinkedServerName>].[<DatabaseName>].DBO.DISCOUNTS J
    WHERE  J.DISCOUNTTYPE = @supervisorID
           AND J.DISCOUNT = (SELECT MAX(B.DISCOUNT)
                             FROM   [<LinkedServerName>].<DatabaseName>.DBO.DISCOUNTS B
                             WHERE  B.DISCOUNTTYPE = J.DISCOUNTTYPE)
    
    GO
    
    ?????????
    • <LinkedServerName>?????? ?????? ???? ???? ?????.
    • <InstanceName>?????? ?????? ???? ???? ???? ?????.
    • <DatabaseName>?????? ?????? ???? ????? ????????.
??? ????? ??? ???????? ????? ????? ????? ???????? ?? ??? "???????".

???????

???? ???????: 936223 - ????? ??? ??????: 18/???/1431 - ??????: 2.0
????? ???
  • 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
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Workgroup
????? ??????: 
kbmt kbsql2005engine kbexpertiseadvanced kbfix kbpubtypekc kbqfe KB936223 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????936223

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

 

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