sp_send_calendar_event
Send Calendar Event / Appointment Invitations (iCal formatted file) from within SQL Server using a CLR stored procedure.
Background
Click here for some background information about this project.
Prerequisites
The instance configuration clr enabled must be turned on, and it will be turned on automatically during the pre-deployment phase of this project.
The CLR assembly in this project requires the UNSAFE permission set.
Installation
If you have SSDT, you can open the SQL server project and publish it to your database of choice.
Alternatively, you can use this simple installation script that sets everything up for you in your database of choice.
Release Notes
This version introduces a few error handling improvements.
It also implements backward-compatibility for older SQL Server versions 2005 and 2008.
The standalone installation script no longer requires the TRUSTWORTHY setting to be turned on.
However, you must place the assembly DLL in a location accessible to the SQL Server instance.
Set the PathToSignedDLL SQLCMD variable to the correct DLL path.
For more information and documentation, please visit the repository page: