Viewing 15 posts - 586 through 600 (of 2,917 total)
I used Dennis Jensen's code (as I could copy-paste to SSMS) then tweaked it to work in SSMS and give some results with ID and DueDate:
USE master
DECLARE...
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 18, 2023 at 6:08 pm
To add to what Jeff (and you) said, I wouldn't throw technology at a problem unless you know that it is the solution. And if you don't know what the...
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 17, 2023 at 5:51 pm
I am not sure what the "best" way to handle this is, but the approach we took was to set up a second job to watch for running jobs. 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.
April 17, 2023 at 4:15 pm
@jefferyjordan26 - my advice would be to ask that recommendation on a vdj forum not a SQL server forum. That being said, I would look at the recommended specs for...
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.
December 28, 2022 at 3:56 am
Now that lists it as a security update but if you actually go to the download page, it is a GDR download which goes back to my previous reply.
As for...
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 30, 2022 at 11:56 pm
Doing a quick google, I found this:
https://stackoverflow.com/questions/23774596/udp-client-and-server-using-ipv6
Quick read on that (it is short) is basically that the network interfaces don't support listening on both IPv4 and IPv6 at the same...
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 30, 2022 at 7:17 pm
With SQL Server 2019, Microsoft doesn't release "Security Updates". All you get are CU's or GDR's and both of these are cumulative update which includes all previous patches. You just...
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 30, 2022 at 7:04 pm
That is crazy... How would SQL Server differentiate between SQLCMD and just some arbitrary application (.NET for example)? Set your connection string right and it would appear identical to SQL...
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 30, 2022 at 4:05 pm
Possibly a dumb question but what problem are you trying to solve? I am just trying to figure out what use case there would be to seeing when any change...
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 27, 2022 at 2:03 pm
Alternately, rather than building that yourself, get a SQL monitoring and reporting tool. The good ones will fire off an alert when a condition is met AND provide you with...
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 27, 2022 at 1:23 pm
Who were the 20 people who answered "The unmasked data from the table"???
I know I am giving a hint at the answer by ruling out one of the possible answers...
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 25, 2022 at 3:53 pm
Tough question for a Friday. At the time of this message, only 24% had it correct...
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 20, 2022 at 4:59 pm
I would strongly encourage you to edit your post and take out the passwords you put in there... you should never post a password in plain text on any forum,...
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 10, 2022 at 1:11 pm
When you say "brought into single user mode but no hope" what do you mean? You got errors?
Now, like Jeff said, I am a bit curious about the licensing on...
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 9, 2022 at 4:52 pm
My opinion - his reasoning is garbage. He should be testing the backups to ensure they are valid. If you don't trust the backup when things are running fine, what...
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 6, 2022 at 9:38 pm
Viewing 15 posts - 586 through 600 (of 2,917 total)