??????? ??????? Management Server 2002 ?????? ????? ?????? Service Pack 2 ???????

?????? ????????? ?????? ?????????
???? ???????: 906145 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

????? ???

????? ??? ??????? ??? ??????? ????? Microsoft ??????? Management Server (MCMS) 2002 Service Pack 2 (SP2).

?????? ??? ???? ?? ????????? ??? ????? ?????? ??? ??? ?????? ??????? Management Server 2002 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
906142????? ?????? ??? ???? ???? ???? ????? ??????? Server 2002

??????? ????

MCMS 2002 ?????? ????? ?????? SP2

????? ???? ?????? ??? ????????? MCMS 2002 Service Pack 1a (SP1a). ????? SP2 2002 MSCMS ??? ??????? ??????? ???? ?? ??????? ????? ??????? ????? ???????. ??? ????? MCMS 2002 SP2 ????? ?? Microsoft .NET Framework 2.0 ?? Microsoft Visual Studio 2005 ? ?? Microsoft SQL Server 2005 ? ???????? 64-??.

??? ????? MCMS 2002 SP2 ????? ?????. ????? SP2 2002 MSCMS ??? ??????? ???? ?? ??????? ?? MCMS 2002 SP1a. ??? ???? ??????? ??? ?? ??? ?? ??? ?????? ?????? "????? ??????" SP2 2002 MSCMS ?? ??? ????? ??? ?????? ??. ??? ???? ??? ??? ?? ??? ?????? ?????? "????? ??????" ?? ???? SP1a 2002 MSCM SP2 2002 MSCM ???? ????? ??? ?????? ???? ???? ?? Visual Studio 2005.

??? ?? ??? ?? ??? ?????? "????? ??????" ???? ? ?? ??? ??? ?? ??? ?????? SP2 2002 MCSM ??? "????? ??????" ??????? ??? ????? ??????? ??????? ??? ?? ????? ?? ??????? "????? ??????" ??????:
  1. ??? ?? ????? SP2 2002 MCSM ????? ??????.
  2. ???? ?? ?? ???? Microsoft Visual Studio .NET 2003 ?? Microsoft Visual Studio .NET 2002 ?????.
  3. ?? ?????/????? ???????, ???? ??? Microsoft SP1a Server ?? ????? ??????? ?? ???? ??? ?????/?????.

    ?????? ???? ?? ???? ????? ??????? ???? ????? ??? MCMS 2002 SP1a ?? ?????? SP1a ????? ???????.
  4. ??? ????? ?? ???? ??? ??????.
  5. ?? ????? ??????? ???? ????? ??????? ??? ????? ?????? ?? ???? ??? ??????. ????? ????? ????? ?????? "????? ??????".
  6. ??? ???????? ?? ????? "????? ??????" ???? ? ????? ???? ?????? SP2 ?????? ?? MCMS 2002.

MCMS 2002 SP2 ? Microsoft Visual Studio 2005

???? ???????? MCMS 2002 Visual Studio ???? ???????? "?????? ??? ?????" ?? Visual Studio 2005. ??? ????? ????? MCMS 2002 ?? Visual Studio .NET 2003 ??? Visual Studio 2005 ???? ????? Visual C# ?? Visual Basic ????? ???? ???. ???? ??? ??????? ??? MCMS 2002 ?????? ???????:
  • ????? ???????? MCMS 2002 ???? ????? ?? Visual C# ? Visual Basic ?? ??????.
  • ????? MCMS 2002 ??? ??? IIS ?????? ??????? ???? ???. ?? ??? ?????? ??? ???????? ??? ??? ??? IIS ?????? ???? FTP.
??? ???????? MCMS ???? ???????? "?????? ??? ?????" ?? Visual Studio 2005 ? ??? ????? ?????? MCMS 2002 ???????? ?????? ???? "??? ?????" ????? ?? ???? ????? ?? ?? ??????? ????. ?? ???? ????? ?????? MCMS 2002 ???????? ?????? ????? ???? ?? ????? ?????? ?? ????? ????? ???? ???? ???? ??? ????? ?? ???? ?????? ?? ????? ??? ?????? ????? MCMS 2002.

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

??????? ????????? ?????? MCMS 2002 ????? ??? ?? Visual Studio 2005 ???? ??? ??????? ???? ????. ???? ???? ??? ??? ????? ???? ??? ??????? ?????? ???????. ???? ????? ?? ????? ????? Project ?????? ????. ????? Visual Studio 2005 ??????? ??????? ?????? ??. ??? ???? ????? ????? ?????? ???? ???? ????? ???? ??????? ???????. ????? ?????? ???? ???????? ??????? "??????" ?? Visual Studio 2005.
  1. ???? ??? ????? ?? ???? ??? ??????.
  2. ????? ???????? ??????? ?? ???? ??? ???.
  3. ???? ???????? ????? ???? ??? ??? ?????????. ????? ?????? ?? ?????? ???? ????? ??????? ???????? Visual Studio ?? ?? ?????? ???? ????? ?????? ???????? Visual Studio. ???? ?????? ???? ????? ??? ?????????.

    ?????? ??? ??? ?????? ??? ????? ???? ???????? ?????? ?? ?????? ??? ?????.
  4. ???? ??? ?????.
?? Visual Studio 2005 ? ???? ????? ???? ????? ??????? ?? ????? ????? "?????". ?? ????????? ??????? ?? Visual Studio .NET ???? ????? ?????? ??????? ?????????. ???????? ?????? ?????? ??? ????? ????? ???? ?????? ?????? MCMS 2002 ?? ????? ????? "?????" ? ???? ??????? ???????:
  1. ???? ??? ????? ? ???? ??? ?????? ?? ???? ??? ?????? ???? ?????????.
  2. ?? ???????? ???? ?????? ???? ???????? ????? ?????? ?????? ?????? ???????? ???? ????? ????? ?????? ?????? ?? ????? ????????.
  3. ??? ???? ???? ?? ???????.
  4. ???? ??? ?????.

????? ASP.NET ?? IIS

??? ??? ?????? .NET Framework 2.0 ? 1 ???? ??? .NET. x ????? ??? ??? ? ???? ?? ????? ??????? ?????? ?? Microsoft ASP.NET ??????? ???. ????? ASP.NET ?? Microsoft Internet ??????? Services (IIS) ? ???? ??????? ???????.

.NET Framework 1. x

  1. ???? ??? ???? ?? ???? ??? ????? ????? cmd ?? ???? ??? ?????.
  2. ??? ???? ?????? ??????:
    % x % \Microsoft.NET\Framework\v1. WindowsDirectory. xxxx \
  3. ???? aspnet_regiis ?i ?? ?? ???? ENTER.
  4. ???? iisreset ?? ???? ????? ??????? ENTER ?????? ????? IIS.

.NET Framework 2.0

  1. ???? ??? ???? ?? ???? ??? ????? ????? cmd ?? ???? ??? ?????.
  2. ??? ???? ?????? ??????:
    \Microsoft.NET\Framework\v2.0.50727\ % WindowsDirectory %
  3. ???? aspnet_regiis ?i ?? ?? ???? ENTER.
  4. ???? iisreset ?? ???? ????? ??????? ENTER ?????? ????? IIS.

MCMS 2002 SP2 ? Microsoft SQL Server 2005

?? ???? ??????? ??????? ???????? Microsoft SQL Server ??? ????? ?????? MCMS 2002 ?? Microsoft SQL Server 2000 ??? SQL Server 2005 ??? ????? ???? ?????? SP2 ?????? ?? MCMS 2002 ??? ????? ???????? ????? ?????? ??? ????? ?????? SQL Server 2005 MCMS 2002:
IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'CreateBackgroundProcessingJob')
	BEGIN
		PRINT 'Dropping Procedure CreateBackgroundProcessingJob'
		DROP  Procedure  dbo.CreateBackgroundProcessingJob
	END

GO

PRINT 'Creating Procedure CreateBackgroundProcessingJob'
GO

CREATE Procedure dbo.CreateBackgroundProcessingJob
		(
		@databaseName sysname
		,@jobName sysname 
		)

AS

/**
 *	This stored procedure is used to create a job to perform the background
 *	processing. The DCA runs this stored procedure for every database when 
 *	the database is created or upgraded.
 *
 *	@param	@databaseName		Name of the database to create the job for
 *	@param	@jobName out		Name of the job created
 *
 *	@return	0 -		Success
 *			1 -		Failure
 *			100 -	The job already exists
 */

begin

	set nocount on
	
	declare @tranCount int
			,@jobId uniqueidentifier
			,@outputFileName nvarchar(250)
			,@jobStepCommand nvarchar(512)
			,@new_job_created tinyint
	
	--localizable strings
	declare @localized_string_InvalidInputParameter as nvarchar(128)
	set @localized_string_InvalidInputParameter = N'Invalid input parameter'
	
	declare @localized_string_JobDescription as nvarchar(128)
	set @localized_string_JobDescription = N'Purge expired information from MCMS tables'
	
	declare @localized_string_JobStep_ExpiredPages as nvarchar(128)
	set @localized_string_JobStep_ExpiredPages = N'Process expired pages'
	
	declare @localized_string_JobStep_DanglingPages as nvarchar(128)
	set @localized_string_JobStep_DanglingPages = N'Purge content for deleted pages'
	
	declare @localized_string_JobStep_GalleryBasedResources as nvarchar(128)
	set @localized_string_JobStep_GalleryBasedResources = N'Update gallery based resources'

	declare @localized_string_JobStep_DanglingBLOBs as nvarchar(128)
	set @localized_string_JobStep_DanglingBLOBs = N'Purge data for deleted resources'

	declare @localized_string_JobStep_DanglingACL as nvarchar(128)
	set @localized_string_JobStep_DanglingACL = N'Purge deleted rights groups from container ACLs'

	declare @localized_string_JobAlreadyExists as nvarchar(128)
	set @localized_string_JobAlreadyExists = N'The job already exists'
	
	--validate input
	if isnull(@databaseName, '') = '' or isnull(@jobName, '') = ''
	begin
		raiserror(@localized_string_InvalidInputParameter, 15, 1)
		return (1)	
	end
	
	--the job Name is the database Name prepended with 'BGP-'
	--set @jobName = cast('BGP-' + @databaseName as sysname)


	--check whether we have to create a category for BGP jobs
	IF not exists (select 1
					from msdb.dbo.syscategories
					where (category_class = 1 /*local*/)
					and (name = 'MCMS Background Processing'))
	begin
		exec msdb.dbo.sp_add_category @class = 'JOB'
									,@Type = 'LOCAL'
									,@Name = 'MCMS Background Processing'
		if @@error <> 0 return (1)	--failure
	end

	
	set @new_job_created = 0
		
	--start a new transaction if the caller has not started one
	set @tranCount = @@trancount
	if @tranCount > 0 
		save tran CreateBGPJob_tran
	else
		begin tran CreateBGPJob_tran
		

	--if the job already exists for this database, clear up all job steps
	if exists (select 1
				from msdb.dbo.sysjobs_view
				where name = @jobName
                and originating_server = lower(CONVERT(NVARCHAR(30), SERVERPROPERTY('ServerName'))))
    begin
		declare @stepcount int
		
		select @jobId = job_id 
		from msdb.dbo.sysjobs_view
		where name = @jobName
        and originating_server = lower(CONVERT(NVARCHAR(30), SERVERPROPERTY('ServerName')))
		
		select @stepcount = count(*)
		from msdb.dbo.sysjobsteps
		where job_id = @jobId
		
		while @stepcount > 0
		begin
			exec msdb.dbo.sp_delete_jobstep @job_name = @jobName, @step_id = @stepcount
			if @@error <> 0 return (1)	--failure	
			
			set @stepcount = @stepcount -1
		end
	end		
	else
	begin
		--create a new job
		exec msdb.dbo.sp_add_job @job_name = @jobName
								,@enabled = 1
								,@description = @localized_string_JobDescription
								,@category_name = 'MCMS Background Processing'
								,@job_id = @jobId output
		if @@error <> 0 goto errorhandler
		
		set @new_job_created = 1
	end

	set @outputFileName = '[SQLDIR]\JOBS\BGP-' + @databaseName + '-[STRTDT]-[STRTTM].log'
	
	--process expired pages
	exec msdb.dbo.sp_add_jobstep @job_id = @jobId
								,@step_name = @localized_string_JobStep_ExpiredPages					
								,@subsystem = 'TSQL'
								,@command = 'exec bgp_ProcessExpiredNodes'
								,@on_success_action = 3
								,@on_fail_action = 3
								,@database_name = @databaseName
								,@output_file_name = @outputFileName
								,@flags = 2
	if @@error <> 0 goto errorhandler

	--gallery based resources
	exec msdb.dbo.sp_add_jobstep @job_id = @jobId
								,@step_name = @localized_string_JobStep_DanglingPages					
								,@subsystem = 'TSQL'
								,@command = 'exec bgp_DeleteDanglingPages'
								,@on_success_action = 3
								,@on_fail_action = 3
								,@database_name = @databaseName
								,@output_file_name = @outputFileName
								,@flags = 2
	if @@error <> 0 goto errorhandler

	--gallery based resources
	exec msdb.dbo.sp_add_jobstep @job_id = @jobId
								,@step_name = @localized_string_JobStep_GalleryBasedResources					
								,@subsystem = 'TSQL'
								,@command = 'exec bgp_UpdateGalleryBasedResources'
								,@on_success_action = 3
								,@on_fail_action = 3
								,@database_name = @databaseName
								,@output_file_name = @outputFileName
								,@flags = 2
	if @@error <> 0 goto errorhandler

	--dangling ACLs
	exec msdb.dbo.sp_add_jobstep @job_id = @jobId
								,@step_name = @localized_string_JobStep_DanglingACL					
								,@subsystem = 'TSQL'
								,@command = 'exec bgp_DeleteDanglingACL'
								,@on_success_action = 3
								,@on_fail_action = 3
								,@database_name = @databaseName
								,@output_file_name = @outputFileName
								,@flags = 2
	if @@error <> 0 goto errorhandler

	--dangling BLOBs
	exec msdb.dbo.sp_add_jobstep @job_id = @jobId
								,@step_name = @localized_string_JobStep_DanglingBLOBs					
								,@subsystem = 'TSQL'
								,@command = 'exec bgp_DeleteDanglingBLOBs'
								,@on_success_action = 1
								,@on_fail_action = 2
								,@database_name = @databaseName
								,@output_file_name = @outputFileName
								,@flags = 2
	if @@error <> 0 goto errorhandler

	--set the second job step as the start step because, by default, we do not
	--process expired postings
	exec msdb.dbo.sp_update_job @job_id = @jobId, @start_step_id = 2 
	
	if @new_job_created > 0
	begin
		--set the schedule	
		exec msdb.dbo.sp_add_jobschedule @job_id = @jobId
										,@Name = 'MCMS Background Processing Default'
										,@enabled = 1
										,@freq_type = 4
										,@freq_interval = 1
										,@active_start_time = 10000
		if @@error <> 0 goto errorhandler

		--notify the SQL Server Agent	
		exec msdb.dbo.sp_add_jobserver @job_id = @jobId
										,@server_name = N'(local)'	
		
		if @@error <> 0 goto errorhandler
	end
	
	--commit if we started our own transaction
	if @tranCount = 0
		commit tran	CreateBGPJob_tran
		
	return(0)
		
errorhandler:
	if @@trancount > 0
		rollback tran CreateBGPJob_tran
		
	return(1)

end
GO

GRANT EXEC ON dbo.CreateBackgroundProcessingJob TO CMSSystem
GO

??????? MCMS 2002 SP2 ???????? ??? ???????

??? ????? SP2 2002 MCMS ??? ????? ??? ??????? ?????? ??????? ?? Visual Studio 2005:
  1. ??? ????? ???? ??? ?????? 2005\Templates Visual Studio:
    1. ??? ???? ????? .zip ?? ?????? ??????:
      MCMS Installation Path\DevTools\NewProjectWizards80\Visual Developer\CSharp\1033 ???
      ???? ??? ??????? ??? ?????? ??????:
      Developer\CSharp\1033 ??? 2005\Templates\ProjectTemplates\Visual Studio Documents\Visual ?????? ??
    2. ??? ???? ????? .zip ?? ?????? ??????:
      MCMS Installation Path\DevTools\NewProjectWizards80\Visual Developer\VisualBasic\1033 ???
      ???? ??? ??????? ??? ?????? ??????:
      Developer\VisualBasic\1033 ??? 2005\Templates\ProjectTemplates\Visual Studio Documents\Visual ?????? ??
    3. ??? ???? ????? .zip ?? ?????? ??????:
      MCMS Installation Path\DevTools\NewItemWizards80\Visual Developer\CSharp\1033 ???
      ???? ??? ??????? ??? ?????? ??????:
      Developer\CSharp\1033 ??? 2005\Templates\ItemTemplates\Visual Studio Documents\Visual ?????? ??
    4. ??? ???? ????? .zip ?? ?????? ??????:
      MCMS Installation Path\DevTools\NewItemWizards80\Visual Developer\VisualBasic\1033 ???
      ???? ??? ??????? ??? ?????? ??????:
      Developer\VisualBasic\1033 ??? 2005\Templates\ItemTemplates\Visual Studio Documents\Visual ?????? ??
  2. ??? ???? ???? ??????? 2005 Visual Studio.
  3. ???? devenv /setup ?? ?? ???? ENTER.

    ?????? ??? ?????? ??????? ?????? ???? ?? ???? ???? MCMS 2002 VSIP.

?????

?????? ??? ???? ?? ????????? ??? ????? IIS ASP.NET ?????? ?? ?????? ???? ???? ????? Microsoft (MSDN) ?????? ??? ?????:
http://msdn2.microsoft.com/en-us/library/k6h9cz8h(vs.71).aspx
?????? ??? ???? ?? ????????? ??? ??? ????? ??? ??? ?? ASP.NET ?? ?????? ???? MSDN ??????:
http://msdn2.microsoft.com/en-us/library/t7604sb9(vs.71).aspx
????? ?? ????????? ??? Visual Studio 2005 ?? ?????? ???? MSDN ??????:
http://msdn.microsoft.com/vstudio

???????

???? ???????: 906145 - ????? ??? ??????: 24/???? ??????/1428 - ??????: 1.4
????? ???
  • Microsoft Content Management Server 2002 Service Pack 2
????? ??????: 
kbmt kbhowto kbcontentmgtserv2002sp2fix kbinfo KB906145 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????906145

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

 

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