Viewing 15 posts - 1,171 through 1,185 (of 2,919 total)
Do you have the same issue if you use the ACE.OLEDB driver or is it a different error?
Or failing that, what about the Visual Fox ODBC driver? It looks like...
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.
June 2, 2021 at 2:42 pm
I agree the post is old, but the information is still relevant.
I would check things like it suggests with process monitor to see if MAYBE there is some access denied...
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.
June 1, 2021 at 7:34 pm
As a thought - are you able to see ANY data or does it return no rows or does it give you an error?
I am not 100% certain, but 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.
June 1, 2021 at 5:41 pm
I would reach out to the company that provided you the driver. Quick google, a "dbf" file is a dBase file.
Quick bit more of googling and I came across a...
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.
June 1, 2021 at 5:25 pm
Pretty sure that REPLACE is going to be the best way to approach that, without changing the underlying data structure and manipulating the data. I prefer to store my addresses...
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.
June 1, 2021 at 4:55 pm
My opinion - with it being on a SAN, there isn't a lot of need to put it on separate disks UNLESS your SAN admin can guarantee that the separate...
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.
June 1, 2021 at 4:47 pm
Is there a reason you NEED to do this in powershell? it feels like it is the wrong tool to me when SQL Server can handle this without the need...
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, 2021 at 8:33 pm
Thinking this link will help:
To paraphrase the important part - your execution timeout period is too short. You will need to specify a longer timeout period. Depending on the size...
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, 2021 at 7:44 pm
I would recommend downloading this:
https://www.microsoft.com/en-us/download/details.aspx?id=50731
That is the LATEST CU for 2012 SP2 which includes the TLS 1.2 stuff. Feels to me like a much safer bet than downloading an older...
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, 2021 at 2:10 pm
For SQL Server 2012, TLS 1.2 (transport layer security 1.2) depends on your SP version. For SP2, it is CU10. For SP1, it is CU3. This can be found here:
As...
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 26, 2021 at 5:22 pm
I kind of expected SQL to be smart enough to not let you re-use files like that during the install, but was just guessing in case that was the issue.
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 26, 2021 at 2:01 pm
"ACCESS DENIED" is actually very informative, depending on where you are seeing it as it SHOULD contain more information such as what access is being denied.
Is that in the 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 25, 2021 at 9:03 pm
From the Microsoft documentation:
When this option is enabled, network communication between DTC services can fall back to non-authenticated communication or to non-encrypted communication if a secure communication channel cannot be...
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, 2021 at 5:21 pm
On top of what Jeff was asking (what the scripts looked like before), I would be curious to see the execution plans for a slow run vs a fast run.
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, 2021 at 5:03 pm
My first thought is that the local user Paolo is a member of a group on the local machine that has additional permissions on the SSRS instance.
That or 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.
May 25, 2021 at 3:48 pm
Viewing 15 posts - 1,171 through 1,185 (of 2,919 total)