Viewing 15 posts - 601 through 615 (of 2,917 total)
So this is a problem because:
A - sa is disabled, so you cannot log in as sa.
B - local machine administrator account is not an admin
What I would suggest is...
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:28 pm
My understanding, and a quick google confirmed what I thought, is that they are essentially the same thing. A FULL backup is a backup of ALL data up until 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.
May 6, 2022 at 9:19 pm
I personally find that the wizards are hit and miss and I prefer to set things up myself where possible. I've had the wizards say "everything is great" only 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.
May 5, 2022 at 9:24 pm
Quick google of that command, it is part of the SqlServer module. My best guess is that your SqlServer module is out of date or corrupted in some form. I...
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 5, 2022 at 9:08 pm
To add to what Michael said, if you run that in SSMS without the debugger, is it taking 30 seconds to grab data from the fetch?
Also, are you SURE 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.
May 5, 2022 at 8:44 pm
To add to what Michael said though about ports - in practice, any port under 1024 (I think... been a while since I did networking stuff) is a "reserved port"...
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 3, 2022 at 7:06 pm
You say you know this error very well, but sometimes it helps to go back to the basics and just double check the VERY basic configuration.
Have you come across 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.
May 3, 2022 at 5:51 pm
The problem is in the error message:
module 'pip' has no attribute 'get_installed_distributions'
quick google of that, that module/attribute was removed in Python. Found this on SO:
Solution - use supported methods 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.
April 18, 2022 at 6:53 pm
Since you are seeing problems from other VM's, I would suspect it is NOT the 2019 box but the 2017 box. BUT you can't rule out that your Azure 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.
April 18, 2022 at 5:12 pm
My guess is that it is not a problem with on-prem, it is a problem with MFA. Personally, I have never set up SSMS or ADS to work with MFA...
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, 2022 at 4:56 pm
This feels almost like an undocumented "feature" (similar to quirky updates)... I know I would be a bit hesitant in how I used this and would probably continue to stick...
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, 2022 at 4:44 pm
I am pretty sure the syntax is just "CREATE CERTIFICATE <certname> FROM FILE=<path to file>", and a quick google confirmed this for me:
Mind you, you likely also want to include...
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 11, 2022 at 3:14 pm
Then you will need multiple get-childitem calls and you will either need to append them all to the same CSV OR store it all in a variable (ie in memory)...
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 8, 2022 at 6:09 pm
For requests 3 and 4, I would say google those. 3 is EASY as that is just a parameter. 4 is pretty easy too as you just need to call...
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 8, 2022 at 5:35 pm
As an alternate suggestion, you could drop the existing database and then do the restore as then you should have the disk space. This is the approach I usually take...
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 7, 2022 at 4:52 pm
Viewing 15 posts - 601 through 615 (of 2,917 total)