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

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

?? ????? ??

?????

?? ???????? ?? ????? ????:
  • ??? ?? ?? ?? ?? ?? ???? ???? ???????? ??????????? ??? Microsoft SQL Server 2012 ??? ???? ???????? ?????? ????
  • SQL Server 2012 (SQL Server 2012 CU1) ?? ??? ????? ?????? 1 ??????? ????, ?? ?? ?? ?????? ???? ???????? ?????? (DQS) ?? ???????? ???? ?? ??? ?? ?? ?????????? ?? ?????? ?? ??? DQSInstaller.exe ????? ??????
  • ???? ?? ???????? ?????? ???? ?? ????? ???? ???? ?? ???? ???????? ??????????? ??? ?? ???? ?? ????? ?? ?????? ?????
?? ???????? ???, ???? ???????? ?????? ??????????? ???? ????, ?? SQL ????? ??????? ???? ?? ???? ??? ??? ?????? ????? ???? CPU ????? ???? ??? ??, sqlservr.exe ????????? ????? ?????

?????
  • ?? ?????? ?? ???????????? ???? ?? ???, ???? ???????? ?????? ?? DQS ???????? ?????
  • ???? ???????? ????????? SQL Server 2012 CU1 ??????? ???? ?? ???? ????? ??? ??, ??? ???? ?? ?????? ??????? ???? ???

????

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

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

????????

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

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

?? ?????? ?? ?? ???? ?? ???, SQL Server 2012 ?? ??? ?????? ?????? ??? ??????? ????? ???? ??????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
2755533 SQL Server 2012 ?? ??? ?????? ?????? ??? ??????? ???? ?? ?????

SQL Server 2012

?? ?????? ?? ??? ????? ???? ????? ?????? 2 ??? SQL Server 2012 ?? ??? ???? ???? ??? ??? ?? ????? ?????? ?????? ?? SQL ????? ?? ??? ??????? ???? ?? ????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
2703275 SQL Server 2012 ?? ??? ????? ?????? ????? 2
??? Builds ????? ???? ???, ??????? ?? ???????? ?? ?? ????? ???? ?? ?? ????? SQL ????? ?? ??? ????? ??? ?? ??? ??????? ???????? ?????? ???? ?? ???? ???? ?????? ?? ???????? ????? ?????? ????? ?????? ????? ?? ????? ??? ???? ??????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
2692828 SQL Server 2012 ?????? ???? ?? ??? ?????? ???? ??? ?? ?? SQL ????? 2012 ?????

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

?? ?????? ?? ???????? ?? ?? ???, ????? ??????? ??? ?? ???? ?? ?? ????? ?????

???? 1

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

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

    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
    ???ID> ???? ???????? ????? ?? ??? ?? ?? ????????? ?? ?????? ID ?? ??????? ???
  3. ???????? ???? ?? ???? ???????? ????????? ?? ???????? ?????? ???? ??????? ?? ?????? ????? ???? ?? ???
???? 2

CPU ???????? ??????? ?? ????? ?? ??? looping ????????? ?????? ?? ??? ??, ?? ????? ??? ??? ???? ?? ????? ???? ?? ??? ?????? ???????, killing looping ????????? ???? ???????? ????????? cleanly ???? ????? Transact 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;

??? DQS ??????? ?????? ?? ??? ???? 2 ?? ????? ???? ???, ?? ?? ???? ???????? ?????? ??? ????? ?????? ????? ??? ???? ??:

SQL Server ???? ???????? ????

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

<MessageId></MessageId>: ApplicationUnhandledException

??????? ????? ??????? ??? ??? ???? ??????? ?? ???, ???? ???????? ???? ??????? ??? ??????

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

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

??????

Microsoft ?? ?????? ?? ?? ?? ?? "?? ?? ????" ???? ??? ???????? Microsoft ???????? ??? ?? ?????? ???

??????

DQS ?? ???????? ???? ???? ?? ???? ??? ???? ??????? ?? ???, ????? Microsoft TechNet ??? ???? ?? ????:
DQS ?? ???????? ???? ????

???

???? ID: 2705571 - ????? ???????: 20 ??????? 2012 - ??????: 4.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 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:2705571

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

 

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