sql server - Can anything else send emails except sp_send_dbmail? -

i'm using sql server 2012.

i plan enable emails on staging server make sure performs planned before going live. i'd emails being sent come own email address , not go real clients, i've hardcoded to, cc, , bcc fields in [sp_send_dbmail] can send me, regardless of parameters being passed in.

the technet page @ http://technet.microsoft.com/en-us/library/ms189635.aspx mentions sp_send_dbmail, , know xp_sendmail no longer available, want sure nothing can emailed clients before enabling email on server.

so before enable emails, know of other sps or xps can send emails may not have considered?

thanks

this resolved now, else looking solution same question though ...

it seems sends emails, or involved emails in sql server 2012 revolves around [msdb].[dbo].[sp_send_dbmail] (previous versions of sql server had xp_sendmail).

so can edit [msdb].[dbo].[sp_send_dbmail], after begin statement, insert following:

 set    @recipients = 'yourdevemail@addresshere.com'  set    @copy_recipients = null  set    @blind_copy_recipients = null  set    @subject = '(staging email) ' + isnull(@subject, '') 

then hijacking recipients of emails being sent through sql , sending email address provide, meaning nothing goes out customers, etc.

you need consider clrs though, , xp_cmdshell.

for not familiar these, clrs compiled assemblies written in other programming language can called , executed sql, , xp_cmdshell runs command shell within sql.

clrs can found in ssms opening db in question in explorer pane, go programmability > assemblies, , existing assemblies in there, these have been compiled, lets see if exist. you'll need find source code these elsewhere, speak whoever developed them, should have saved somewhere (hopefully).

xp_cmdshell can execute can execute in windows command shell, calling other programs or batch files initiating emails. you'll need search calling xp_cmdshell yourself, redgate sql search helping this.