-- Stored Procedure: dbo.ArchUtilChangesByDate
-- 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].[ArchUtilChangesByDate]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[ArchUtilChangesByDate]
GO

CREATE Procedure ArchUtilChangesByDate
 /* Param List */
AS

/******************************************************************************
** File: dbo.ArchUtilChangesByDate.PRC
** Name: admin.dbo.ArchUtilChangesByDate
** Desc: List changes on server, most recent changes first
**
** Auth: Bill Wunder
** Date: 7-25-2003
*******************************************************************************
** Change History
*******************************************************************************
** Date:  Author:  Description:
** -------- -------- ---------------------------------------
**    
*******************************************************************************/
set nocount on

select  SQLServerName
 , DatabaseName
 , VSSItem
 , VSSParent
 , VSSItemType
 , ChangeAction
 , cast(cast(RecCreatedDt as varchar(11)) as datetime) as [Date]
 , RecCreatedDt
from admin.dbo.ArchUtilChanges
order by RecCreatedDt desc
GO
SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO