Just to add, if you don't want to look at it after it happens, review who the sysadmins are on the system currently, verify that they are all using Windows...

Another approach which may not be ideal due to it being a lot of work to impelment but could work in your situation would be to build up a "reporting"...

My opinion on this would be to design this a bit differently. Let SQL handle the SQL stuff and use WQL to handle WQL stuff. IF the WQL needs to...

I tried to do this with my team ages back, I simulated database corruption - instance is online but checkdb comes back dirty and can't recover it on it's own....

Just a thought - does that the server with that setting OFF is sitting with a LOT of open transactions, right? I think you likely want it ON so your...

I use AI to help with some code BUT it has a lot of oversight by me. I mostly use it for little scripts here and there and bug fixing...

It sounds like you are running the query across multiple SERVERS, not databases or tables, then you really only have 3 options:

1- use linked servers

2- export to file instead of...

My only bit of advice would be to do this on a TEST system first and get testing done on all impacted applications before cutover. Also have a post migration...

So the reason (I suspect) is that you are using string_agg wrong. I don't have sample data from you to test things, so just guessing here, but I'd start by...

If the package isn't deployed, then Visual Studio tracks the time. No need to look at the database side. If you need to track the time on the database side,...

Just to expand on your article a bit in terms of hidden heroes - pretty much all of IT is a "hidden hero". Without them, companies would suffer a lot...

If it is just 1 stored procedure causing it and not everything coming from that system, I would suspect that the code is different between the 2 systems and that...

Just wanted to point out - that parameter not existing is what I (and others on here) have been saying the whole time, so it is no surprise that it...

My next best guess is that something in the connection string is setting it (not likely as I don't think you can set that in there), in the driver (possibly),...

as a guess, I think that can be a default on the instance level (maybe database level), so it may be set on the server not in the web service.

Failing...