

--select * from msdb.dbo.sysmail_profile
  --select * from msdb.dbo.sysmail_account
  --select * from msdb.dbo.sysmail_profileaccount


  --delete from msdb.dbo.sysmail_profile
  --delete from msdb.dbo.sysmail_account
  --delete from msdb.dbo.sysmail_profileaccount

  --update sysmail_profileaccount set sequence_number = 2 where profile_id = 2 and account_id = 2



----------------------------------------------------------------

EXEC msdb.dbo.sp_send_dbmail  
    @profile_name = 'CMMS Admin',  ----here name of admin we want to send 
    @recipients = 'daryl@evantage.com.my',  
    @body = 'Voila..!! This email has been sent from SQL Server Express Edition.',  
    @subject = 'Voila..!! This email has been sent from SQL Server Express Edition.' ;