Viewing 15 posts - 1,456 through 1,470 (of 2,918 total)
I would reach out to Microsoft on this one as it sounds like a bug that they will need to fix.
December 17, 2020 at 7:44 pm
If they are not rendering on workstations, it sounds like the fonts are not properly installed on the workstations.
My first step when working with fonts is to make sure that...
December 17, 2020 at 7:42 pm
I think you are missing a "LEFT" on your RIGHT. You have the RIGHT side of the string, but have too much. So, what you probably want is:
December 16, 2020 at 9:22 pm
My understanding of this - the assembly needs to be signed outside of SQL Server. If you have the source code to the assembly, then you should be able to...
December 16, 2020 at 4:53 pm
Did you follow the directions in the error message?
"By default, only administrators have access to the Integration Services service. On Windows Vista and later, the process must be running with...
December 15, 2020 at 6:54 pm
My first question would be why are you running that from SSIS? That feels like overkill when windows task scheduler can handle it perfectly well. And failing that, SQL Server...
December 15, 2020 at 2:34 pm
I am pretty sure the proper way to fix that you need to change the service account for the SQL instance to a domain account. Once that is changed, you...
December 14, 2020 at 9:46 pm
For the first question - writes refers to changing data. a SELECT will have 0 writes, while an INSERT, UPDATE, or DELETE will have 0 or more writes. A "write"...
December 14, 2020 at 9:43 pm
I can't speak for the scale out part, but for the rest, I think it really depends.
For the ports, I recommend any that are not in use and that your...
December 14, 2020 at 8:16 pm
To add to Ant-Green's comment, you may want to capture what queries are being run as sa too. Knowing that sa logged in is one thing, but if it is...
December 8, 2020 at 3:56 pm
I forgot about the advent of code as well. They are fun (and challenging) puzzles for sure. Would be nice if they listed some global "rules" like that the solution...
December 8, 2020 at 3:51 pm
That is also a lot of NOLOCK hints... are you sure you need those?
I wonder if you'd get a performance boost by dumping the data to a temp table or...
December 7, 2020 at 9:56 pm
Is this advertising your product or spam?
If you could provide more details about what the tool does and why we would want to use it, without us having to go...
December 7, 2020 at 4:57 pm
As Anthony Green indicated, permissions can be granted to anything in SSRS.
What I am guessing you did is had it set up with inherited permissions, then removed permissions at the...
December 4, 2020 at 9:46 pm
What error are you getting? If you don't know, check the logs. That will tell you why it isn't starting and give you a good starting point to resolving the...
December 4, 2020 at 4:48 pm
Viewing 15 posts - 1,456 through 1,470 (of 2,918 total)