-- View: dbo.vw_DBSize -- 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].[vw_DBSize]') and OBJECTPROPERTY(id, N'IsView') = 1) drop view [dbo].[vw_DBSize] GO create view vw_DBSize as select DbName, DataFileSize_KB, LogFileSize_KB, LogFileSizeUsed_KB, SampleDate from dbperfhistory GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO