Add Outlook appointments from stored procedure

We are using SQL 2005, Outlook 2003 and Exchange Server 2003.
I need to add appointments to individual users outlook calendars from within a SQL 2005 stored procedure based on a date and time entered into a database table.  I do not need to worry about scheduling conflicts.  It would be nice if I could remove the appointment from outlook if the record was deleted in the database, but I do not have to update the db if the user changes the appt in outlook ( at least not yet ).

Who is Participating?
since you are using sql server 2005 you can use clr stored procedures and triggers
check this link
for c# code to create appointment in outlook

all you need to do is create a clr trigger on that table that will run the above code after insert
you could try to implement the appointment removal using a delete trigger, but i don't know if you would be able to pull it of if the user had changed the date and time of the appointment
WaterstoneAuthor Commented:
Thanks momi.  I will take a look at this next week and see if it will work with our exchange server.
WaterstoneAuthor Commented:
Sorry it took so long to close this.  Solution worked and we are all set.  Thanks!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.