<div>
I realize i posted this in both the 2000 and 2005 forums... but<br />
<br />
That appears to be a SQL 2005 only proc. &nbsp;Are their any for 2000 or can i port that one( i assume not )?<br />
<br />
Thanks!
</div>


I realize i posted this in both the 2000 and 2005 forums... but

That appears to be a SQL 2005 only proc.  Are their any for 2000 or can i port that one( i assume not )?

Thanks!

<div>
I needed 2000, but you provided an answer for 2005. &nbsp;Since i didnt state it in my original question and you did provide a solution, i am awarding the points for effort and possible solution if i upgrade.<br />
<br />
Thanks
</div>


I needed 2000, but you provided an answer for 2005.  Since i didnt state it in my original question and you did provide a solution, i am awarding the points for effort and possible solution if i upgrade.

Thanks

<div>
<div class="content wysiwyg-content">
Just wondering if anyone knows how to do this in SQL.<br />
<br />
I can send emails with .ics attachments via CDO.message, but they come with without any buttons, the user has to open the attachment to create the appointment. &nbsp;<br />
<br />
Also, is there &nbsp;a way to format the email in such a way that you do not need to include the file as an attachment.. just sent a direct email from sql.<br />
<br />
Thanks
</div>
</div>


Just wondering if anyone knows how to do this in SQL.

I can send emails with .ics attachments via CDO.message, but they come with without any buttons, the user has to open the attachment to create the appointment.  

Also, is there  a way to format the email in such a way that you do not need to include the file as an attachment.. just sent a direct email from sql.

Thanks

Format email from SQL server the same way gmail formats vcalendar emails

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.