Forum Replies Created

Viewing 15 posts - 1,456 through 1,470 (of 2,917 total)

  • Reply To: Barcode fonts not rendering in report view or PDF export

    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...

    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.

  • Reply To: SQL removing characters

    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:

    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.

  • Reply To: Running a SQL Server 2008 database with CLR on SQL 2019 with strict security

    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...

    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.

  • Reply To: Connection to SSIS after upgrade

    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...

    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.

  • Reply To: PowerShell Process Task fails in locked down Windows 10

    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...

    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.

  • Reply To: Linked server failure

    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...

    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.

  • Reply To: Different Duration of the same queries

    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"...

    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.

  • Reply To: Polybase

    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...

    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.

  • Reply To: how to capture login 'sa' begin used ot not

    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...

    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.

  • Reply To: Practice Your Skills with the Advent of Code

    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...

    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.

  • Reply To: Order By Slowness

    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...

    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.

  • Reply To: Troubleshooting for Amazon RDS

    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...

    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.

  • Reply To: SSRS site settings security and Home folder Security

    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...

    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.

  • Reply To: SQL services not starting after upgrading TLS 1.0 to TLS 1.2

    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...

    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.

  • Reply To: There are no SQL Server instances or shared features that can be updated -2017

    Was just reading the error message and it sounds like the installer thinks that you are trying to install the wrong CU.

    I would try re-downloading CU 22 and see 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.

  • Viewing 15 posts - 1,456 through 1,470 (of 2,917 total)