Viewing 15 posts - 436 through 450 (of 2,917 total)
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...
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 13, 2023 at 2:17 pm
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...
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 12, 2023 at 9:36 pm
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...
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 12, 2023 at 7:35 pm
The steps I am aware of are:
1 - find the bottleneck - is it the Lake, is it the network, is it the internet, is it the power BI processing,...
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 12, 2023 at 7:05 pm
To add to what Jonathan said - do you understand the code? If person A is supporting it now and understands the code and they are leaving and you are...
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 12, 2023 at 7:03 pm
First comment on this, I think you will get more/better results on a PostgreSQL form than a SQL Server forum. That being said, PostgreSQL has documentation on authentication. Have you...
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 11, 2023 at 7:27 pm
First thing I'd check is "what changed?". If it worked prior to a certain date and suddenly stopped working, something changed. Step 1 is to figure out what changed and...
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 7, 2023 at 6:36 pm
To add to what Jeff said, there are a lot of things mentioned in this thread to check. If it is a scheduled "crash" of the instance, then you likely...
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 7, 2023 at 2:00 pm
This looks like a case for a UNION. You do your main SELECT then UNION a SELECT of the ID and the date minus 1 day. There is probably another...
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 4, 2023 at 7:45 pm
I agree with Erland - installing 2008 R2 in 2023? yikes... BUT you may have a good reason, so do what you gotta do, but that's never fun installing such...
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 1, 2023 at 4:01 pm
I'm saying I don't remember if it calls a logout or if it leaves the connection open in a suspended state (ie open but doing nothing) when it completes. I'm...
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 1, 2023 at 2:02 pm
I'd be a little curious if it is related to the exact process you are running (failing to drop the database due to replication) OR if it could be something...
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.
November 29, 2023 at 8:02 pm
I think it really depends on the problem you are trying to solve. I am guessing you read the comments to the SSC post here:
https://www.sqlservercentral.com/forums/topic/script-all-logins-users-and-roles
If you are looking to re-create...
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.
November 29, 2023 at 7:53 pm
My troubleshooting steps are always the same - review the logs, reproduce the problem on a test system, and go from there. From what I found on google, it sounds...
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.
November 29, 2023 at 7:31 pm
I have not tested this, but any chance you have implicit transactions turned on in your instance?
If not, I'd open up a support case with Microsoft as nobody on this...
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.
November 29, 2023 at 7:23 pm
Viewing 15 posts - 436 through 450 (of 2,917 total)