Forum Replies Created

Viewing 15 posts - 2,656 through 2,670 (of 2,919 total)

  • RE: Deinstall express edition

    I think you'd want to have the same installation media.  As you pointed out, using incorrect installation media cannot remove all of the features.

    But Microsoft offers 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.

  • RE: The infamous double quote and semicolon error for CSV-files. Not experiencing the issue in 2008R2, but in 2016.

    A difference between the OP and Phil Parkin's post that I noticed is that the OP used the code page 65001, and Phil used 1252.

    I am wondering 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.

  • RE: Speed up Openquery

    This could be a dumb question as I don't know a lot about oracle, but isn't there an ODBC connection for oracle?  If so, couldn't you run the whole thing...

    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: XCOPY failing via xp_cmdshell

    badOedipus - Wednesday, April 12, 2017 10:53 PM

    A dbcc freesessioncache command should clear the plain text password from the logs.

    That should clear...

    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: Connecting to Named Instance

    I betcha windows saw the app get changed when you did windows updates so it thought it was a different app (the hash of the file didn't match up).  

    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: Connecting to Named Instance

    Glad I could help.  I knew you could add programs through too, I just personally like having the port instead of the whole program as it feels like I have...

    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: Speed up Openquery

    How slow is the query if you run it directly on the server instead of through openquery?
    and what if you use a linked server connection and just use 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.

  • RE: SSRS results to be exported to SFTP folder

    Any reason not to set up a file share on a network drive with restricted permissions (IT department and SSRS account for example) that could store the reports and then...

    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: Deinstall express edition

    The easy way is to use add/remove programs.  But if that isn't working, I'd download a copy of SQL Express (it is free), and use that to remove the instance.

    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: Connecting to Named Instance

    As a thought - does connecting as hdcvs-lims-sql\ss2016, 49559 work?  I expect that it will.

    If so, then it is likely your firewall is blocking connection on port 1434...

    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: Deinstall express edition

    When you say the original media files are not present, do you mean the installation files or do you mean the "c:\program files" folder for SQL express got deleted?
    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.

  • RE: Simple licensing for upgrade question

    I agree with Sue that MS will likely be your best bet.  But I know from talking with their licensing experts that they use the term "expert" loosly.  I talked...

    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: TSQL Like caluse does not work

    komal145 - Tuesday, April 11, 2017 3:08 PM

    I need to find the model from the given strings :
    STRINGS GIVEN:
    Iphone 6 Screen Rota
    Apple...

    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: Alternating Cursors?

    Jeff Moden - Monday, April 10, 2017 5:30 PM

    bmg002 - Monday, April 10, 2017 4:26 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: Alternating Cursors?

    As an alternate to using a cursor for each DB, could you use:
    EXEC sp_Msforeachdb 'INSERT INTO #nonexistent (IndexName,TableName,DB)
    SELECT ic.IndexName,ic.TableName,DB_NAME() AS DB
    FROM MONITORING.dbo.IDXCHECK ic
    LEFT OUTER...

    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,656 through 2,670 (of 2,919 total)