Hey, we got a similar script in our Madeira toolbox:

https://github.com/MadeiraData/MadeiraToolbox/blob/master/Utility%20Scripts/Shrink%20All%20Shrinkable%20Transaction%20Logs.sql

Hi,

I'd suggest a couple of things:

1. It's not entirely clear from your code and it just might be a formatting issue on my phone... But it looks like you have...

That's a good point, @fedan

Thank you for your comment.

I should refactor the code a bit so that the separator character would be a comma "," instead of a...

@fedan , I've added support for a new "Proxy" header in my own version.

Please see if it helps:

https://github.com/MadeiraData/ClrHttpRequest

It's plausible but it sounds like way too much effort, too many moving points of failure and it would require significant ongoing maintenance effort.

May I suggest a simpler, more elegant...

I believe implementing a "master control job" which automatically disables or enables jobs as needed is a far more elegant solution.

I delivered a couple of webinars about it:

https://eitanblumin.com/portfolio/how-to-hadr-your-sql-jobs/

Accompanying...

Hello Francesco,

Are you using the latest version from Eilert's GitHub or mine?

If not, please refer here:

https://github.com/eilerth/sqlclr-http-request

Or here:

https://github.com/MadeiraData/ClrHttpRequest

Hey, it's been a long time since anyone responded on this thread, but in case anyone is interested, I've recently published a blog post dealing with this issue of clustered...

I've recently developed an open-source solution in CLR for sending calendar invitations (ical / ics) from within SQL Server.

This works:

https://github.com/EitanBlumin/sql_clr_ics

Eilert,
Thank you so much for writing and publishing this! This is brilliant piece of work!
Your code is incredibly clean, versatile and easy to use.
We have already integrated...

Looks very interesting and a very cool looking feature.

Will this work even if I don't have a SQL Server 2012 machine? (only SQL 2008 for example)