FIX: ????? ??? ??? ?????? ????? ???????? ??? ????? ?? ????? ???????? ??? ?? SQL Server 2005: "????? 548 ? ????? 16 ???? 2? ??? 1. ??? ???????"

???? ??? ????????? ??????. ?? SQL Server 2005 ?????? ????? ???. ????? ???? ????? ??? ???? ???? ??? ????? ???. ?? ??? ????? ?????? ?? ?????? ?? ??????. ?????? ???????? ??? ??????? ?????? ?? ?????? ????? ?????? ?????? ?? ??????. ?? ??? ?????????? ???? ????? ????? ??????? ??? ??????: ??? ????? ????? sp_adjustpublisheridentityrange ?? ??????? ?????? ??? ?????? ??? ??? ?? ????? ????? "? ?? ???? ????? ?? ??? ???????.

???? ??? ??????? ??? ?????? ??? "????? ???" ???????? ?? ??? ????? ?????? ??? ???. ???? ?? ???? exacerbated ??? ??????? ??? ??? ???? ?????? ?? ????????? ?? ????? ???.

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

?? ????? ??????? ????? ???? ??????? ????? ?? ??????? ???????? 8. ????? ?? ????????? ??? ????? ?????? ??? ???? ??????? ???????? ??? ?? SQL Server 2005 ?????? ????? ?????? SP2 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:?????? ??? ????????? ???????? ????? ?? ????? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2005 ??????? ???????. ???? Microsoft ?????? ????? ???? ????? ??????? ???? ????? ??? ??? ??????? ??????. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:??? ????? ????????? ??????? Microsoft SQL Server 2005 ??? ???? SQL Server ?????. ??? ????? ??????? ???? SQL Server 2005 ?????? ????? ?????? SP2 ??? ????? SQL Server 2005 ?????? ????? ?????? SP2. ???? ???????? ??? ????? ????????? ??????? ???????? ?? ???? ???? ?? SQL Server ?? ???? ???? ?? SQL Server ???????.

??????? ?????? ??? ??? ??????? ??? ??? ????? ??? ????????? ??????. ?????? ????? ?? ?????? ??????? max_concurrent_merge ??? ????? ??? ?????? ????? ??????? ???????: ?????? ??? ??????? ??? ???? ? ?????? ?? ????? ??? ??? ???? ?????? ?? ????????? ???????. ???? ??? ?????? ???? ????? ???? ??? ???? ?????? ???????? ?? ?? ???.

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

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

?????? ?? ??? ??? ????? ??? ??????? ???? ??????? ???????:

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

   SELECT IDENT_CURRENT ('<TableName>')

   ??????? ??? ?????? ???? ??? ???? ?? ??? ???? ???? ????? ?? ?? ???????? ???????:
   ???? 1

   sp_helpconstraint '<TableName>'

   ??????? 2

   select * from MSmerge_identity_range
   where is_pub_range <>1
   AND artid IN 
    (select artid from sysmergearticles where name='<TableName>')
   AND subid in 
    (select subid from sysmergesubscriptions  MS
   join sysmergepublications MP 
   on MS.subscriber_server=MP.publisher
   AND MS.db_name = MP.publisher_db
   WHERE name='<PublicationName>'
   )
   

2. ?????? ???? ???? ????? ??????? ???? SQL ?????? ?? ??? ??? ??? ????? executions ?????? ?? ??????? sp_MSsetup_publisher_idrange ????? ??? ????? ??? "??? ????" ?????? ??? ???????.
   
   ??? ???? executions ?????? ?? ??????? sp_MSsetup_publisher_idrange ????? ?? ???? ????? ??? ?????? ??? ???????. ???? ???? ??? ????? SQL Server ???? ????? ??????? ??? ????? ??????? ?????? ?????? ?????? ??? ??? ????? ???. ????? executions ?????? ?? ??????? sp_MSsetup_publisher_idrange ????? ????? ?????? ?????? ??? ???????.
3. ????? ?????? ??? ????? ??? ????????? ???? ???? ??? ???? ????? ????? "548". ?????? ????? ????? ?????? ??????? ??? ?? ????? ?????? ???????. ?????? ????? ?? ?????? ???????? ???????: max(time)

   Use distribution
   GO
   select session_id, agent_id, B.publication, min(time) as StartTime, max(time) as EndTime
   into #sessiontimes
   from dbo.MSmerge_history A
   join dbo.msmerge_agents B
   on A.agent_id = B.id
   group by session_id, agent_id, publication
   order by 3 desc
   GO
   -- The left side result is the original session. The right side result is the overlapping session.
   select A.*, B.* 
   from #sessiontimes A
   Join #sessiontimes B
   On B.StartTime >= A.StartTime
   AND B.StartTime <= A.EndTime
   AND A.session_id <> B.session_id
   And A.publication=B.publication
   Order By A.StartTime asc
   GO
   drop table #sessiontimes
   

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

??? ????? ??????? ???????? ?? ??? ??????? ??????? ??????? ?? ??? "???? ?????? ?? ??? ????? ???? ???? ???? ????? ?? ????. ??? ??????? ???? ????? ????? "548" ??? ?????? ????? ?????? ?? ?????? ?????? ???????? ??? ?????. ????? ??? ?? ?????? ????? ?????? ???? ??????? ???? ??????. ?????? ????? ???? ??????? ???????.

?????? ????? ??? ??????? ?????? ????? ???? ???? ?????? ??????? ?????? ?????? reseed ???? ?????? ?? ?????? ???? ????. ?? ???? ??? ?????? ?????? ??????? ???? ?? ???? ???? ????? ?? ??? ???? ?? ??? ???? ???? ??? ????? ????????. ??? ??????? ?????? ?????? ???? ??? ???? ???? ???? ????? ?????? ??? ???? ?? ??? ????? ???????? ???? ???? ????? ??????. ????? ??? ??????? ?? ??????? ?? ?? ??????? ?????? ?????? ??? ?????? ??????? ???? ?????? ??? ???? 1.

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

   SELECT IDENT_INCR( '<TableName>')

2. ????? ??????? ??????? ??? Publisher ?????? ??? ???? ?????? ??????? ??? ???? ????? ?????:

   DBCC CHECKIDENT ('<TableName>')

   ??? ???? ??????? ???? ?????? ???? ?????? ??????? ???????? ?? ????? ???? ???. ???? ?? valye ???? ?????? ?????? ?? ???? ?? ???? ?? ?????? ???? ?????? ???????.
   
   ??? ???? ?????? ???? ?????? ?????? ???? ?? ?????? ???? ?????? ??????? ? ???? ?????? ?? ???? ?? ????? ?? replications ?????? ?? ?????????? ?? ??? ????? ?? ????? ???????? ?? Publisher. ??? ???? ?????? ???? ?????? ?????? ???? ?? ?????? ???? ?????? ??????? ????? ?? ?? ??????? ?? ?????? ?? ??? ???? ???????? ON IDENTITY_INSERT SET ????? ??? ????? ????? ???????? ?????.
3. ????? ???????? ??????? ??? Publisher ????? ?????? ?????? ??????? ?? ???? ???? ???? ??? ????? ?????: sp_helpconstraint

   Use <PublishedDatabaseName>
   GO
   sp_helpconstraint '<TableName>'
   GO
   

   ??? ???? ??????? ???? ???? ?????? constraint_keys ??? ??? ?? ???? ?????? constraint_name "repl_identity_range_ GUID. ???? GUID ????? ???? ?????? artid ??????? ?? ???? ?????? sysmergearticles. ?????? ??? GUID ?? ?????? ??????? ???????:

   select artid from sysmergearticles where name = '<TableName>'

   ??? ???? ?? ??? ???? ???? ???? ?????? ??????. ?? ???? ?? ??????? ?????????? ?? ????????. ??? ???? ??????? ???? ?? ???? ???? ?????? constraint_keys ??? ???:
   ([ColumnName] > (1001) ? [ColumnName]<=(2001)
   OR [ColumnName] > (9001) ? [ColumnName]<=(10001))
   ?????? ?????? ??? ??????? ??? ?????? ???? ????????? ???????? ?? ???? ???????.
   
   ?? ??? ??????? ???? ???????? ?? ????? 1,000. 1,000 ?? ??? ?????? ?????????. ??? ???? ????? ????? ??? ???? ?????? ???????? ??? ???????? ???????:
   • ????? @ pub_identity_range ??????? ??? ????? sp_addmergearticle ?? ??????? ??????.
   • ????? ????? ??? ?????? ??????? ??????? ?? ???? ?????? ????? ?????.
4. ?? ???? ?????? ??????? ??????? ?? ??? "???????" ? ??? ?? ???? ???? ?????? ??????? ???? ??? ??????? ?? ?????? 2 ???? ?? ???? ?????? ?????? ???? ????? ?? ??? ???? ?? ??? ???? ?????? ???? ??? ??????? ?? ?????? 3.
   
   ??? ???? ?????? ?????? ??????? ?? ?????? 2 ???? ?? ?????? ???? ???? ?????? ???? ???? ???? ????? ? ?? ??????? ?? ???? ??????? ??????? ???????? ?? ????? ?????. ????? ??? ????? ??????? sp_adjustpublisheridentityrange ??????? ??? ??????.
   
   ????? ?? ????????? ??? ??????? sp_adjustpublisheridentityrange ????? ?? ?????? ???? ???? ????? Microsoft (MSDN) ?????? ??? ?????:
   http://msdn.microsoft.com/en-us/library/ms181527.aspx

   (http://msdn.microsoft.com/en-us/library/ms181527.aspx)
5. ????? ??????? ??????? ?????? ?? ??? ??? ???? ??? ???? ?? ?????? ?????? ??????? ??? ???? ?? ??? ???? ??????:

   SELECT COUNT(*) FROM TableName WHERE 
   ([ColumnName]>(1001) AND [ColumnName]<=(2001) 
   OR [ColumnName]>(9001) AND [ColumnName]<=(10001))
   

   ?????????
   • ??? ???? ??????? ???? 0, ??? ???? ?? ???????? ?????? ???????. ?? ??? ??????? ????? ??? ?????? 6.
   • ??? ???? ??????? ???? ???? ???? ?? 0 ????? ??????? ??????? ?????? ??? ???? ????? ???? ?????? ?? ???????? ?????? ???????:

     SELECT MAX(ColumnName) as MaxValue FROM TableName WHERE 
     ([ColumnName]>(1001) AND [ColumnName]<=(2001) OR 
     [ColumnName]>(9001) AND [ColumnName]<=(10001))
     

     ???? ?????? ???? ?? ??????? ??? ?? ????? ??? ?????? 7.
6. ?????? reseed ?????? ??????? ????? ????? ??? ???? ???? ????.
   
   reseed ?????? ??????? ??? ??? ???? ?????? ?????? ??????? ???????? ??? 1. ??? ???? ??????? ??? ???? ?????? ??? ?? ?????? ?????? ??????? 1001 ??? ???? ?? ???? ???????? ???? 1002 ?????? ?????? ????? ???? ??? ???? ?? ??? ???? ???? ???? ?? (&gt;). ?????? ????? ?? ?????? ??????? ??????? ??? ?????? ?? ?? ????? ??? ?????? ??? 8:

   DBCC CHECKIDENT ('TableName', RESEED, 1002)

7. ?????? reseed ?????? ??????? ????? ????? ??? ???? ???? ????.
   
   ????? ?? ????? ?????? ?? 1. reseed ?????? ??????? ??? ?????? ???? ??? ??????? ?? ?????? 5 ?? ?? ?????? 1. ??? ???? ??????? ??? ???? ?????? ???? ??? ??????? ?? ?????? 5 1507 reseed ?????? ??????? ??? 1508. ?????? ????? ?? ?????? ??????? ??????? ??? ??????:

   DBCC CHECKIDENT ('TableName', RESEED, 1508)

8. ?? ?????? ?????? ?????? ?? ??? ???? ???? ????? ???? ??????? ?? ?????? ?? ????? ?????? ???? ??? ???? ??? 548.

?????? ??? ???? ?? ????????? ??? ??????? ????????? ???? ????? ??? ???? ?????? Service Pack 2 ?????? ?? SQL Server ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft: ????? ?? ????????? ??? "????? ????? ??????" ?? SQL Server ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:?????? ??? ???? ?? ????????? ??? ????? ?????? ??? SQL Server 2005 ?????? ????? ?????? SP2 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft: ????? ?? ????????? ??? ??????? ??????? ?????????? ?? SQL Server 2005 ?????? ????? ?????? SP2 ?? ?????? ???? Microsoft ?????? ??? ?????:?????? ??? ???? ?? ????????? ??? ???? ??????? ?? SQL Server ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:????? ?? ????????? ??? ??????? ????? ??????? "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft: