I could be dumb, but this really sounds like a homework/assignment style question. That being said, if I asked something like this, my first question would be "what does the...

I suppose that is a good point Jeff. In this specific scenario where the OP is trying to write the file to the server itself, having the data flow from...

One nice thing is that with email notifications, things show up how you would expect. The other fun thing is it happens outside of the code block too:

those above...

Oh I agree with you here Jeff. When things are set up properly, xp_cmdshell can be secure, but I find that a lot of times, it is used and abused....

@steve-2 Jones - replace the _ with a space and you'll see what's happening.

If there are no jobs (maintenance plans are still jobs) or scheduled tasks, then I'd say something must be happening on the Azure side of things that is backing it...

My opinion - don't. Firstly, SQLCMD mode is a client side thing (ie part of SSMS) not a server side thing (ie not part of SQL Server Engine) so SQLCMD...

My question would be do you need to use replication for this?

What I mean is could you modify the stored procedure that updates the primary to ALSO update the secondary...

If I understand correctly, could you do something like this:

SELECT [T1].* -- or could do [T2].*, not certain which table row you are trying to show, you...

• This reply was modified 1 year, 8 months ago by Mr. Brian Gale.

Thanks for the links Frederico_fonseca - unfortunately it is not a docker thing. In my case it looks like it is a vulnerability scan and it is just driving me...

Thanks for the tip! I'll send a question out to the IT team as I would LOVE to have that fixed... although I am a bit concerned that changing it...

Another thing to point out - your data looks to be inconsistent:

A DB 130 9/1/2023
A DB 120 10/1/2023

why did "DB" shrink by 10 MB that day/month?

But in...

My opinion, you are going to need a tool to do that. Offhand, I am not sure what tool can handle it, but anything that supports WMI should be able...

I agree with Jeff - if the code is complex or confusing, it should have comments around those bits explaining the logic. Now, if the code is confusing to someone...

Just to add to what Phil said - that SHOULDN'T exist in the real world. I have run across some things that make me scratch my head like storing numeric...