In SQL 2005, is there a way to send an file as an read only. I tested with an Excel file and its properteis shows read only and i cant edit it. When the same is sent over db mail, it becomes editable. How to fix this?
I believe this would depend on the source file you're sending. If the Excel file is read-only or password protected, then it keeps those properties when you email it through Outlook, database mail or another mail program. If you're trying to have SQL dynamically generate a file and then send it as read only, I don't know of a way to do that.