Viewing 15 posts - 1,096 through 1,110 (of 2,917 total)
I think it would help to see current output and expected output.
Looking at what you wrote, I don't see why it would add a comma in front of closing date...
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 23, 2021 at 2:20 pm
That error usually means a COM object is not registered correctly. I am not sure what COM object corresponds to that CLSID, but if you can determine that, you MAY...
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 23, 2021 at 2:19 pm
I think the first step is to define user requirements.
My understanding of an "air gapped" system is that the system is on an isolated network with limited access to 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.
June 22, 2021 at 9:28 pm
Glad you found the answer. Could you share it with the group?
I know I have not seen this issue before. Generally though, I have a different habit. I disable 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.
June 22, 2021 at 7:50 pm
Question 1 - As far as I am aware, three is no limit on the SSRS side, but there is a limit in how long the URL can 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 22, 2021 at 4:19 pm
How much free disk space do you have? Can tempdb grow?
Also, is that 200MB the data size, the log size, or combined? Knowing the individual values would help.
Lastly, what 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.
June 22, 2021 at 2:21 pm
With my experience, installing CU's or SP's via WSUS is a slow and painful process where it happens one instance at a time and generally needs a reboot between installs.
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 21, 2021 at 5:31 pm
This sounds like a better question for your licensing provider than a random forum post, but I can try to help here.
Best I can tell, there is no difference between...
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 21, 2021 at 5:16 pm
Just to confirm - the totals when you run it unfiltered are NOT showing up, but when running it filtered, they ARE showing up?
If the above is correct, I would...
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 21, 2021 at 5:07 pm
As a guess, could it be permission related? I am wondering if you are running it with a restricted account and you need a full sysadmin to see all of...
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 21, 2021 at 5:05 pm
Something I'd like to add to what Jeff said - where do you want to handle this? Should this be handled at the INSERT level or at the SELECT level?
Also,...
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 21, 2021 at 4:54 pm
A quick google of this, it looks like CONTEXT_INFO is not a property that is available at connection time. So you would need to SET that after connecting. This could...
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 21, 2021 at 4:39 pm
Glad I could help. I am actually a bit surprised that SSL connections would be faster than non-SSL. I am actually not sure why that would be as SSL adds...
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 21, 2021 at 2:31 pm
Quick google of that error, it sounds like there is more to the error message. Is the full error message:
Msg 8921, Level 16, State 1, Line 1 Check terminated. 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 18, 2021 at 4:47 pm
I see a few optimizations that can probably take place.
First, that WHERE 1=1 isn't needed as it isn't doing anything. Not sure it is a performance improvement by removing 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.
June 18, 2021 at 4:27 pm
Viewing 15 posts - 1,096 through 1,110 (of 2,917 total)