Peter Gadsby (11/10/2009)

---

I dont understand why we don't get the error 'files requires an integrated client login.'

We can use a local login to send an email with an attachment!

Books Online

---

Database Mail uses the Microsoft Windows security context of the current user to control access to files. Therefore, users who are authenticated with SQL Server Authentication cannot attach files using @file_attachments. Windows does not allow SQL Server to provide credentials from a remote computer to another remote computer. Therefore, Database Mail may not be able to attach files from a network share in cases where the command is run from a computer other than the computer that SQL Server runs on.