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



create procedure dbo.EmptyTablesByDBEmailReport
 @recipients varchar(100) 
as
declare @message varchar(1024)
 , @query varchar(1000)

set nocount on


set @message = 'Tables with the no rows.' + char(13) + char(10) + char(13) + char(10) +
  'Exclude a table from this report by adding a' + char(13) + char(10) +
  'row to admin.dbo.EmptyTablesByDBExcludeList'

exec sysmon.dbo.safe_sendmail  @recipients = @recipients
    , @subject = 'Empty tables in each db'
    , @message = @message
    , @query = 'exec admin.dbo.EmptyTablesByDB'
    , @width = 80



GO
SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO