SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[vssCompareDatabaseGrande]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[vssCompareDatabaseGrande]
GO


create procedure dbo.vssCompareDatabaseGrande
	@pDatabaseName varchar(255),
        @pEnvironmentName varchar(30) = null,  
	@pTempFolder varchar(255) = null
as
/**********************************************************************************
Wraper to compare 
***********************************************************************************/
-- common
declare @returnstatus int,
	@error int,
	@procedureName varchar(100)

set nocount on

set @procedureName = db_name() + '.' 
		+ user_name(objectproperty(@@procid,'OwnerId')) 
		+ '.' + object_name(@@procid)

exec @returnstatus = Admin.dbo.dbo.vssCompareDatabaseToVss
	@pDatabaseName,
	@pEnvironmentName,
	@pTempFolder

set @error = @@error
if @error <> 0 or @returnstatus <> 0
	goto ErrorHandler

exec @returnstatus = Admin.dbo.vssCompareWorkToVss @pDatabaseName

set @error = @@error
if @error <> 0 or @returnstatus <> 0
	goto ErrorHandler

return

ErrorHandler:
insert Admin.dbo.ActivityLog (activity)
select @procedureName + ' ' + @pDatabaseName 
	+ ' ' + isNull(@pEnvironmentName,'') 
	+ ' ' + isNull(@pTempFolder,'') 
	+ ' failed with returnstatus: ' 
	+ cast(@returnstatus as varchar(10)) 
	+ ' error: ' + cast(@error as varchar(10)) 

raiserror(59001,16,1,@procedureName)

return -1

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO