The best tool for this is sql profiler as mentioned by AJ Ahrens

for using the trusted connection, just leave the user id and password from the connectionstring parameter (not even mentioning it). It will automatically uses trusted connection to connect to the sql...

SQL Mail directly does not use any port communication. Insteady It uses MAPI client to send and receive mails. Once If you create a mail profile that is enough to...

there is one more way...

select top 1 id from (

select top 2 id from tmp_tmp_tmp order by id desc)

as tmp order by id

this is so simple. we can do it in 2 steps.

step 1: build the html file using sp_makewebtask

step 2: by using the sp_smtp_sendmail, you can send mail.

and sp_smtp_sendmail is a...