Database Size Notification

• gupta1282

  Default port

  Points: 1465

  More actions

  November 2, 2009 at 7:05 am

  #135903

  Respected All

  Is there any way to get notified when DB Size crosses a particular size limit in sql server 2005 Express Edition

  SQL SERVER Express Edition size is 4 GB but some time we did not monitor size and application generates error.

  Thanks

  Ghanshyam

• homebrew01

  SSC Guru

  Points: 55548

  More actions

  November 2, 2009 at 9:11 am

  #1073855

  There's probably a better way, but this should work:

  select count(*)

  frommaster.sys.databasesas DB

  inner joinmaster.sys.master_filesas MF on MF.database_id = DB.database_id

  where DB.name = 'Express_DB'

  and MF.name = 'Express_Data'

  and (MF. /131072.) >3.5

  if @@rowcount > 0

  EXEC msdb.dbo.sp_send_dbmail

  @recipients = 'YourName@YourCompany.com',

  @subject = 'Express Database over 3.5 Gig'