You could also configure a SQL Server Agent Alert to run a transaction log backup job when more than a specified percentage of the log is used.   I...

I went to see ROS with my brother-in-law and nephew between Christmas and New Year and I thought it was pretty good.  There were plot holes you could drive a...

• This reply was modified 5 years, 8 months ago by Neil Burton.

What do you mean, Neil? The question states the data is encrypted in 2016, moved to 2017. There's no "up to date" here. The algorithm changes. You can't xfer...

Thanks Grant.  The next day or so is going to be spent testing things.  I want to make sure I'm not planning something completely stupid before I spend any more...

I have to say I think this is a bit naughty.  The usual assumption is that all servers involved in a question are up to date. In this case though,...

Thanks Neil,

I assumed this level of disdain, to those less experienced, had disappeared twenty years ago from technical forums - apparently not.

I will not be asking too many questions...

• This reply was modified 5 years, 8 months ago by Neil Burton.

Absolutely not.  Mr Celko, while undeniably hugely knowledgeable, seems to...

As in most development the code should speak for it self, and you should use:

<li style="list-style-type: none;">

<li style="list-style-type: none;">

<li style="list-style-type: none;">

<li style="list-style-type: none;">

• Source control...

If you're worried about Alexa listening to everything, I can say that it (she?) doesn't listen when I ask to switch the bloody cellar lights on so I'd be surprised...

OK, we're getting somewhere now.

The big question is how to you unambiguously tie folder to folder2.  I can see what you want to do but there's no way to guarantee...

Hello and welcome to the forum.

You almost certainly don't need a cursor for this but to get the best help we'll need a bit from you.  It's much easier to...

This may sound like an extremely basic question but what's the difference between an execution error and a syntax error in this case?  The message that I get suggests that...

• This reply was modified 5 years, 10 months ago by Neil Burton.
• This reply was modified 5 years, 10 months ago by Neil Burton.

But why are you copying the code the get the answer in the first place..?

Trust but verify 🙂  Besides, a true smart-alec would have known that a '\' would be...

I copied,  pasted and ran the code as-is and got the wrong answer.

It'll have to be a cowboy outfit.