FIX: ????? ????? ???? ????? ?? ??????? ???? ????? ?????? ?? ??????? ??? "????????? ?????????" ??? ??????? ????? ?????? ???????? ?? SQL Server 2008 R2 ?? ?? SQL Server 2008

?????? ????????? ?????? ?????????
???? ???????: 2793580 - ??? ???????? ???? ????? ????? ??? ???????.
???? Microsoft ?????? ??????? Microsoft SQL Server 2008 R2 ?????? Pack 2 (SP2) ???? ???? ???????. ??? ????????? ????????? ?? ????? ???? ????? ??? ???? ????????? ??????? ?????? ????? ???? ??????? ?????? ???? ?? ??????? ?? ??????? SQL Server 2008 R2 Service Pack 2.
????? ???? | ?? ????

?? ??? ??????

?????

???? ??? ??????? ??????? ???? ????? ?? ??????? ???? ????? ???????? ?? ?????? "???????? ?????????" ????? ??? ??????? ????? ?????? ???????? ?? Microsoft SQL Server 2008 R2 ?? ?? Microsoft SQL Server 2008.

??????? ????

????? ?? ??????? ???? ????? ?????? ???????? ?? SQL Server. ???? ???????? ??? ????? ???? ????? ???????? ?? ??????? ??? "????????? ?????????". ?? ??? ??????? ?? ??????? ????? ????? ?? ???? ??????. ?????? ??????? ???? ???? ?????? ?? ????????? ?????? ??? ??? ???????? ????? ?? ???? ????? ????:
  • snapshots.notable_query_text
  • snapshots.notable_query_plan
??? ????? ??? ???????? ????? ??????? ??????????????????????? ?? ????? ??????? ??????? ????? ??? ?????? "????????? ?????????". ????? ????? ??????????????????????? ???? ?? ??? ??? ???? ????? ???????? ???????.

<ns:QueryActivityCollector xmlns:ns="DataCollectorType">
<Databases IncludeSystemDatabases="True" />
</ns:QueryActivityCollector>
?????? ???? ???????? ??? ????? ???? ??????????????????????? ??? True.

??? ???? ??????? ????? ????? ??????? ?????? SQL ???????? ??????? ???????? ????? ?????? ??????:
USE MSDB
GO
 
DECLARE @collection_item_name NVARCHAR(128);
DECLARE @parameters xml;
DECLARE @collection_set_uid uniqueidentifier;
DECLARE @collection_set_id int;
 
DECLARE @collection_item_id int;
 
SET @collection_set_uid = N'2DC02BD6-E230-4C05-8516-4E8C0EF21F95';
 
SET @collection_item_name = 'Query Statistics - Query Activity';
 
SELECT @collection_set_id = collection_set_id
FROM syscollector_collection_sets 
WHERE collection_set_uid = @collection_set_uid;
 
 
SET @collection_item_id = NULL;
SELECT @collection_item_id = collection_item_id
FROM syscollector_collection_items_internal 
WHERE collection_set_id = @collection_set_id 
    AND (name = @collection_item_name OR name = @collection_item_name);
 
 
SELECT @parameters = convert(xml, N'<ns:QueryActivityCollector xmlns:ns="DataCollectorType">
<Databases IncludeSystemDatabases="false" />
</ns:QueryActivityCollector>');
 
 
EXEC dbo.sp_syscollector_update_collection_item 
        @collection_item_id = @collection_item_id, 
        @parameters = @parameters;

????

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

??????? ???????? 7 ? SQL Server 2008 R2 ?????? Pack 2 (SP2)

??? ????? ??????? ????? ???? ??????? ???? ??? ?? 7 ??????? ????????. ????? ?? ????????? ??? ????? ?????? ??? ???? ??????? ???????? ??? ? SQL Server 2008 R2 Service Pack 2? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2844090 ???? ??????? ???????? 7 ? SQL Server 2008 R2 Service Pack 2
?????? ??? ??????? ???????? ????? ?? ????? ????? ???? ??? ???? ????????? ??????? ?????? ????? ???? ??????? ?????? ???? ?? ??????? ?? ??????? SQL Server 2008 R2 Service Pack 2. ???? ???? ???????? ????? ???? ????? ??????? ???? ????? ??? ??? ??????? ??????. ?????? ??? ???? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2730301 ???? R2 2008 ???? SQL ???? ?? ??????? ??? ????? SQL Server 2008 R2 ?????? Pack 2

??????? ???????? 10 ? SQL Server 2008 Service Pack 3

??? ????? ??????? ????? ???? ??????? ???? ??? ?? 10 ??????? ????????. ????? ?? ????????? ??? ????? ?????? ??? ???? ??????? ???????? ??? ? SQL Server 2008 ???? ?????? 3? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2814783 ???? ??????? ???????? 10 ? SQL Server 2008 ???? ?????? 3
?????? ??? ??????? ???????? ????? ?? ????? ????? ???? ??? ???? ????????? ??????? ?????? ????? ???? ??????? ?????? ???? ?? ??????? ?? ??????? SQL Server 2008 ???? 3 ????. ???? ???? ???????? ????? ???? ????? ??????? ???? ????? ??? ??? ??????? ??????. ?????? ??? ???? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2629969 ???? 2008 ???? SQL ???? ?? ??????? ??? ????? SQL Server 2008 ???? ???? 3

??????? ???????? 5 ? SQL Server 2008 R2 ???? ?????? SP2

???? ???? ??????? ????? ???? ??????? ????? ?? 5 ??????? ????????. ????? ?? ????????? ??? ????? ?????? ??? ???? ??????? ???????? ??? ? SQL Server 2008 R2 SP 2? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2797460 ???? ??????? ???????? 5 ? SQL Server 2008 R2 Service Pack 2
?????? ??? ??????? ???????? ????? ?? ????? ????? ???? ??? ???? ????????? ??????? ?????? ????? ???? ??????? ?????? ???? ?? ??????? ?? ?????? SQL Server 2008 R2 2 ???? ?????. ???? ???? ???????? ????? ???? ????? ??????? ???? ????? ??? ??? ??????? ??????. ?????? ??? ???? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2730301 ???? R2 2008 ???? SQL ???? ?? ??????? ??? ????? SQL Server 2008 R2 ?????? Pack 2

?????

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

?????

????? ?? ????????? ??? ????? ?????? ????????? ????? ??? ???? ??? MSDN ??????:
??????? ???? ??? ????? ?????? ????????

???????

???? ???????: 2793580 - ????? ??? ??????: 09/?????/1434 - ??????: 4.0
????? ???
  • Microsoft SQL Server 2008 R2 Service Pack 2
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Workgroup
????? ??????: 
kbqfe kbfix kbsurveynew kbexpertiseadvanced kbmt KB2793580 KbMtar
????? ????
???: ??? ????? ??? ??????? ???????? ????? ?????????? ??????? ?????? ??? ??????? ?? ??? ??????? ?? ??????? ??? ??? ?? ???? ????????? ???? ??????? ???????(CTF) ?? ?? ???? ????? ????. ???? ?? ???? ?????????? ??? ???????? ???????? ???? ??? ?? ???????? ??????? ?? ??? ??????? ???????? ?? ??? ??????? ??????? ??? ?????? ?? ?????? ??? ???? ???????? ???????? ?? ????? ??????? ????? ????? ??????. ??? ?? ???????? ???????? ?? ????? ??? ????? ?? ???????? ?? ???? ????? ?? ?????. ?????? ??? ???? ?????????? ???? ?????? ?? ??? ????? ?? ??? ??? ?? ??????? ?? ??? ????? ?? ???? ????? ????? ?? ????? ??????? ???? ?? ???????? ?? ??? ???????.
???? ??? ????? ??????? ?????? ??????????2793580

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

 

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