Forum Replies Created

Viewing 15 posts - 2,236 through 2,250 (of 2,917 total)

  • RE: String column shows up as Number Stored as text error

    I think what you would want is something like in this webpage:
    https://jwcooney.com/2015/03/02/ssrs-simple-code-examples-of-handling-null-or-blank-date-fields/
    or this page:
    https://www.experts-exchange.com/questions/20862294/cint-error-when-field-is-null.html

    basically, you want to check if the value is blank...

    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.

  • RE: Restoring database A also tries to Restore database B

    Could you post your restore script?

    I have personally not experienced this, but I am wondering if maybe something in your restore script it touching DB B.

    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.

  • RE: Changing Domains and can't change service user

    Update - so I tried everything in the SSRS configuration that I could find to change the user and every time it is the same thing.  Works great with every...

    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.

  • RE: Accessing database from laptop in hotel room

    What I used to do in situations like that is instead of getting a static IP from my ISP (which cost extra money) is to use a free DNS service...

    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.

  • RE: hMailServer 5.6.7 - B2425.

    Honestly, I have no idea.

    I would recommend looking at the requirements for that application.  Glancing at the manual for SmarterMail version 5, it says that SQL Server 2005...

    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.

  • RE: Licensing Question in a P2P environment

    This is a better question for the Microsoft licensing experts on Microsoft's website, but I believe that SQL Server is licensed per core in most cases, but I think 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.

  • RE: hMailServer 5.6.7 - B2425.

    I don't think that hMailServer is a product offered by sqlservercentral and as such, it is unlikely that you will get much support here for that.
    You would likely get...

    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.

  • RE: Changing Domains and can't change service user

    Strangely, I was doing more testing today and it seems that as long as I am not using the account B\sqlacct_test it works.  Even using B\me it works fine.

    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.

  • RE: Are You a Traffic Cop?

    Sean Lange - Wednesday, March 21, 2018 9:42 AM

    Yeah I have pushed for the the free ones and was met 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.

  • RE: Are You a Traffic Cop?

    Sean Lange - Wednesday, March 21, 2018 7:30 AM

    bmg002 - Tuesday, March 20, 2018 2:49 PM

    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.

  • RE: Are You a Traffic Cop?

    Sean Lange - Tuesday, March 20, 2018 2:34 PM

    To be fair I think nearly everyone works in an atypical place. Sort...

    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.

  • RE: Are You a Traffic Cop?

    Sean Lange - Tuesday, March 20, 2018 1:59 PM

    bmg002 - Tuesday, March 20, 2018 1:51 PM

    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.

  • RE: Are You a Traffic Cop?

    Mike Hinds - Tuesday, March 20, 2018 5:18 AM

    'There's a joke that a DBA's favorite word is "no". '

    Actually,...

    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.

  • RE: The Last iPhone

    I have actually used android since my first smart phone.  I am on phone number 4 with it and learned a lot of things with it over the years.  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.

  • RE: 15 seconds pending execution

    sgmunson - Tuesday, March 13, 2018 1:24 PM

    bmg002 - Thursday, March 8, 2018 10:21 AM

    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 - 2,236 through 2,250 (of 2,917 total)