Viewing 15 posts - 1,846 through 1,860 (of 2,917 total)
Step 1 - check the logs. SSRS logs, SQL Server logs, and Windows event logs. One of those will have more information about the error.
If the logs are not helpful,...
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 15, 2020 at 9:20 pm
I agree with Steve here.
On top of that, if you are wanting someone to help with a project, you should provide some details on the project. Is it strictly 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 15, 2020 at 5:47 pm
I just read the article and I think I am a mix of gatekeeper and flexible. Some things I see as hard-fast rules that should not be debated with new...
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 15, 2020 at 3:07 pm
To recovery the master key, if the password is known, you run (the button for adding SQL is missing for me right now, sorry for the poor formatting):
OPEN MASTER KEY...
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 15, 2020 at 2:44 pm
My first thought is it the same version of DTExec on your machine and the server?
One thing I am reading about that particular error (0x800004005) makes it sound like error...
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 12, 2020 at 8:40 pm
Since you are on 64-bit and Enterprise Edition, it is likely that the system is running out of memory to process the data.
I would check things out on the server...
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 12, 2020 at 7:24 pm
How large is the file? From what I remember (and a quick bit of googling), SSRS doesn't limit file types by default and I'm not even sure it supports limiting...
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 12, 2020 at 6:04 pm
Few things i would check before looking at upgrading from 2016 to 2017. My expectation is that upgrade won't help, but it might if it is a 32-bit vs 64-bit...
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 12, 2020 at 5:20 pm
It seems that it is the two operators following each other "/-" that causes unexpected behavior (not the minus at the beginning).
SELECT -100.0/-100.0*10.0 => 0.1
SELECT (-1*100.0)/-100.0*10.0 =>0.1
SELECT -100.0/(-1*100.0)*10.0 =>...
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 12, 2020 at 2:24 pm
My opinion, that should work. I see no obvious reason why it wouldn't work.
The only case where I can see it being problematic is would be if you set database...
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 11, 2020 at 9:58 pm
Is sharepoint referencing the SQL Instance directly, or is it referencing the web interface? If it is referencing the web interface, then you don't have much to worry about 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.
June 11, 2020 at 9:52 pm
I personally have not seen that error before, but my first thought here is going to be either permissions or a typo.
First step that I would do is if 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.
June 11, 2020 at 8:37 pm
My first thoughts on this are that renaming a SQL instance is tricky and can be problematic. I would recommend picking a name that works for the new server if...
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 11, 2020 at 7:29 pm
I think the only way to limit this is to put restrictions on the linked server itself.
What I mean is to set the authentication on the linked server to 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.
June 11, 2020 at 3:39 pm
I agree with all of the comments. To add to this though, if you want to search inside files and not use powershell, astrogrep is my tool of choice.
My process...
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 11, 2020 at 2:24 pm
Viewing 15 posts - 1,846 through 1,860 (of 2,917 total)