-- Stored Procedure: dbo.InsertArchUtilChanges
-- Bill Wunder

use admin
GO
SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

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

create procedure dbo.InsertArchUtilChanges
 @SQLServerName sysname
 , @DatabaseName sysname = null
 , @VSSItem nvarchar(128)
 , @VSSParent nvarchar(255) 
 , @VSSItemType varchar(7) 
 , @ChangeAction varchar(50) 
as
/******************************************************************************
** File: dbo.InsertArchUtilChanges.PRC
** Name: admin.dbo.InsertArchUtilChanges
** Desc: add a SourceSafe change action
**
** Auth: Bill Wunder
** Date: 7-25-2003
*******************************************************************************
** Change History
*******************************************************************************
** Date:  Author:  Description:
** -------- -------- ---------------------------------------
**    
*******************************************************************************/

insert admin.dbo.ArchUtilChanges 
 (SQLServerName
 , DatabaseName
 , VSSItem
 , VSSParent
 , VSSItemType
 , ChangeAction)
values
 (@SQLServerName
 , @DatabaseName
 , @VSSItem
 , @VSSParent
 , @VSSItemType
 , @ChangeAction)
GO
SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO