{"repo":"MadeiraData/sql-clr-ics","free":true,"listed":false,"github":"https://github.com/MadeiraData/sql-clr-ics","clone":"git clone https://github.com/MadeiraData/sql-clr-ics.git","description":"Send Calendar Event / Appointment Invitations (iCal formatted file) from within SQL Server using a CLR stored procedure","language":"TSQL","stars":11,"topics":["sql-server","sql-clr","smtp-client","calendar-events","ics","mail","email","ical","mssql","mssqlserver"],"license":"MIT","category":"databases-storage","readme_excerpt":"sp send calendar event Send Calendar Event / Appointment Invitations (iCal formatted file) from within SQL Server using a CLR stored procedure. In this page: - Background - Prerequisites - Installation - Syntax - Arguments - Result Sets - Remarks - Examples - License and Copyright - Acknowledgements - See Also Background Click here for some background information about this project. Prerequisites The CLR assembly in this project can only be deployed to a SQL Server with CLR enabled, and support for 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. Syntax Arguments [ @profile name = ] 'profile name' Is the name of the profile to send the message from. The profile name is of type sysname , with a default of NULL. The profile name must be the name of an existing Database Mail profile. When no profile name is specified, sp send calendar event checks whether @from address was specified. If not, it uses the default public profile for the msdb database. If @from address wasn't specified, and there is no default public profile for the database, @profile name must be specified. [ @recipients = ] 'recipients [ ; ...n ]' Is a semicolon-delimited list of e-mail addresses to send the message to. The recipients list is of type nvarchar(max) . Although this parameter is optional, at least one","default_branch":null,"files":null,"tree":[],"storefront":"/r/MadeiraData","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/MadeiraData/sql-clr-ics/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}