Thanks for the feedback.  How did you load the polygon information for the test.  I'm not so familiar with it and it seems like it only takes literal strings and...

BWAAA-HAAA!!!  Whew!  I feel much better about what you're doing now.  Thanks for the feedback, Albert.

The reason why I asked what you're doing the conversion...

I have some data that i have no control over (third party supplying the data). I am extracting it to a CSV but the end user does not want...

This is old but Maybe it will help someone. I had the same issue, a ghost clean up spid was blocking backup jobs and checkpoints at times. When I...

You may have a much larger issue on your hands.  Are the passwords in clear text or...

I wonder how you got a "Jeff Query" out of this thread.  I don't have any code posted. 😉

Unfortunately, they'd probably say the same things they said on the CONNECT site for years and years and they are now saying on the FEEDBACK site.  "Works as designed" or...

Actually, there IS a problem with having a large log file and that would be the sometimes huge amount of extra time a RESTORE would take.  Restoring a log file...

What are the exact errors that you're seeing? (Copy'n'Paste, please)

Update.....I'm staying up watching the logs! Just saw something in there. Invalid login with the admin account to ReportServer. Guessing this in an SSRS thing? Have had issues with...

You should be able to use RAISERROR with a severity of, say, 16.  Please see the following for more info on RAISERROR.

https://docs.microsoft.com/en-us/sql/t-sql/language-elements/raiserror-transact-sql?view=sql-server-ver15

From a lot of the code I've seen, no refactoring would be necessary. 😀

I saw those in your code.  Like I said, well done on the article.  I've not seen such a collection of methods for calculating what Easter Day is all in...

Thanks.  I was coming up against the very same thing and I was trying to avoid the use of any form of dynamic SQL.  For now, that seems improbable at...