When I tried to send mail using xp_sendmail on a PC which is on network but
not a part of a domain I get the following error:

Server: Msg 17985, Level 16, State 1, Line 0
xp_sendmail: Procedure expects parameter @user, which was not supplied.

If I do it on a server logged on as administrator it sends the email.
However, the from in the email is my email address rather than the email
address of the administrator. Where does it take from? I do not have
anything set up either in 'SQL Mail' or 'Database Mail'.

How To incorporate table-valued function in Common Table Expressio
Getting 10 Records the Fastest Way Possible // ROWLOCK, UPDLOCK, READPAST
Using ranking functions in a subquery to feed a CLR function values in a specified order.
Challenging Query - Please Help
JOIN Question...