Sending email from mssql 2008

For creating email profile

EXEC msdb.dbo.sp_send_dbmail
    @profile_name = 'Ratno Profile',
    @recipients = 'ratnokustiawan@amikom.ac.id',
    @body = 'The stored procedure finished successfully.',
    @subject = 'Automated Success Message' ;

Can’t drop DB in Recovery mode (MSSQL 2008)

ALTER DATABASE <database_name> SET PARTNER OFF