Viewing 15 posts - 1 through 15 (of 2,917 total)
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 7, 2026 at 6:09 pm
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"...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 21, 2026 at 9:00 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 21, 2026 at 7:06 pm
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....
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 20, 2026 at 9:24 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 10, 2026 at 7:01 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 9, 2026 at 5:08 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 9, 2026 at 4:59 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 9, 2026 at 4:57 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 23, 2026 at 8:45 pm
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,...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 20, 2026 at 10:28 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 20, 2026 at 8:23 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 17, 2026 at 2:02 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 16, 2026 at 6:02 pm
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),...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 13, 2026 at 5:25 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 11, 2026 at 9:53 pm
Viewing 15 posts - 1 through 15 (of 2,917 total)