FIX: SQL Server ?????? ????? ?????? ???? ?? ????????? ??? ?????? ??? ????? ????? ?????? ??? ????? 1 ??????? ???????? ? SQL Server 2012

???? ???????: 2705571 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???????? ????? ????? ??????? ?????? ?????? ???????
???? Microsoft ?????? ??????? Microsoft SQL Server 2012 ???? ???? ???????. ??? ????????? ????????? ?? ????? ???? ????? ??? ???? ????????? ??????? ?????? ????? ???? ??????? ?????? ???? ?? ??????? ?? ??????? SQL Server 2012.
????? ???? | ?? ????

?? ??? ??????

???????

???? ??? ????????? ??????:
  • ????? ????? ???? ?? ???? ?? ?????? ????? ???????? ?? "?????? ???? ????????" ?? Microsoft SQL Server 2012.
  • ????? 1 ??????? ???????? ? SQL Server 2012 (SQL Server 2012 CU1)? ??? ?? ???? ?????? ????? DQSInstaller.exe ???? ????? ????? ????? ???????? (???) ??????? ??????? ?????? ?????? ?????.
  • ????? ?????? ??? ??? ?????? ????? ???????? ???? ?? ??????? ???????? "?????? ????? ??????".
?? ??? ?????????? "?????? ????? ????????" ???? ?? ?????????? ????? ???? ?? ?????? ?? ???? ????? ?????? SQL Server. ???????? ??? ???? ????? ????? sqlservr.exe ??????? ???? ????? ?? ???? ???????? ????????.

??????
  • ?????? ?? ??? ???????? ?? ?????? ????? ?????? ????? ???????? ????.
  • ???? ??? ??????? ??? ??? ?? ????? ??????? ????? ???????? ??? ?? ??? ????? SQL Server 2012 CU1.
???? ??? ?????? | ????? ???????

?????

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

?????????? ??? ??????? ???? ???? ?????? ?? SQL Server 2012 CU1.
???? ??? ?????? | ????? ???????

????

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

??????? ???? ?????? ??? SQL Server 2012

??? ??? ???????? ??? ?????? ??? ???? ???? ???? ? SQL Server 2012. ?????? ??? ???? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2755533
(http://support.microsoft.com/kb/2755533/ )
????? ?????? ??? ???? ???? ???? ? SQL Server 2012

SQL Server 2012

????? ??? ??????? ??? ???? ??? ?? ??????? ???????? 2 SQL Server 2012. ????? ?? ????????? ??? ????? ?????? ??? ???? ??????? ???????? ??? ? SQL Server? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2703275
(http://support.microsoft.com/kb/2703275/ )
???? ??????? ???????? 2 ? SQL Server 2012
?????? ??? ??????? ???????? ????? ?? ????? ????? ???? ??? ???? ????????? ??????? ?????? ????? ???? ??????? ?????? ???? ?? ??????? ?? ??????? SQL Server. ???? ???? ???????? ????? ???? ?? ??????? ??????? ???? ????? ??? ??? ??????? ??????. ?????? ??? ???? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2692828
(http://support.microsoft.com/kb/2692828/ )
???? 2012 ???? SQL ???? ?? ??????? ??? ????? SQL Server 2012
???? ??? ?????? | ????? ???????

???? ??????

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

??????? 1

?????? ????? ??????? ???? ???? ?? ?????? ???????? ??????? ?????? ??????? ?? ?? ?????? ???? ????? ???? ??????? ???????:
  1. ?? ?????? ????????? ?????? ?????? ??? ???? ??????? ??????? ???? ????? ???:

    SELECT 'KnowledgeManagement'+CAST(ID AS NVARCHAR) AS SchemaName, Name FROM DQS_MAIN.dbo.A_KNOWLEDGEBASE WHERE TYPE=2
  2. ??????? ???? SchemaName ?? ?? ???? ?? ?? ?????? ?????? ?????? ??? ??? ?? SQL Server ????? Studio ?????? ?????? ??? ?????? ????? "??????? ????? ????????". ???? ????? ????? ????? ???? ?????? ???????? ????? ???????? ????????. ?????? ?????? ???? ?? ?????? ???? ????.

    USE DQS_PROJECTS
    GO
    CREATE PROCEDURE DQProject<ID>.NewIndexParseTrigramsFromLexicon

    AS 
    BEGIN
    PRINT 'THIS IS A DUMMY PROCEDURE TO MAKE DELETE WORK for Microsoft KB Article 2705571';
    END
    ??????????> ???? ???? "??????? ????? ????????" ???? ??? ???? ??? ????????.
  3. ???? ?? ?? ??? ??? ??????? ????? ???????? ?? "?????? ????? ????????" ??? ?? ?????.
2 ???????

??? ??? ???? ???? ??????? ????? ????? ?????? ??? ????? ???? ???????? ????????? ?? ?????? ???????? ??????? ?????? ???? ????? ??????. ??? ???? ??? ???? ?? ???? ??????? ????? ??? ??? ??????? ????? ???????? ?????. ?????? SQL ???????? ??????? ????? ?? ????? ???? ???? ??????. ??? ??? ???? ????? ?? ???? ?? "?????? ????? ??????" ??? ???????? ?? ???? ??? ????? ???????? ??? ????:

DECLARE @session smallint, @text nvarchar(2000), @killcommand nvarchar(200)

SELECT TOP 1 @session=s.session_id, @text=st.text

FROM sys.dm_exec_sessions s

FULL OUTER JOIN sys.dm_exec_requests r ON s.session_id=r.session_id

CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) AS st

WHERE program_name like 'DQ Services Client: Client Id = %, KB Id = %, Proxy = KnowledgebaseManagementEntryPointClient'

AND s.status='running';

SELECT 'Killing this DQS session:', @session SessionID, @text QueryText;

SET @killcommand=N'Kill '+ cast(@session as nvarchar)+';'

EXEC sp_executesql @killcommand;

?????? ??? ??? ?????? ????? 2 ???? ??? ???????? ?? ????? ????? ??????? ?????? ??????? ?? "?????? ????? ??????":

????? ????? ?????? ???? SQL

--------------------------------------------------------------------------------

<MessageId></MessageId>: ???????????????????????????

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

--------------------------------------------------------------------------------

System.Data.SqlClient.SqlException (0x80131904): ??? ??? ????? ?? ????? ??????. ???????? ??? ????? ??? ?? ??? ?????.
???? ??? ?????? | ????? ???????

?????

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

?????

????? ?? ????????? ??? ????? ????? ???? ????? ??? ???? ??? Microsoft TechNet ???????:
????? ????? ???
(http://social.technet.microsoft.com/wiki/contents/articles/8442.upgrade-dqs-installing-cumulative-updates-or-hotfix-patches-on-data-quality-services-en-us.aspx)
???? ??? ?????? | ????? ???????

???????

???? ???????: 2705571 - ????? ??? ??????: 04/?? ??????/1433 - ??????: 3.0
????? ???
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Express
  • Microsoft SQL Server 2012 Web
????? ??????: 
kbqfe kbmt KB2705571 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????2705571
(http://support.microsoft.com/kb/2705571/en-us/ )
???? ??? ?????? | ????? ???????

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

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