Forum Replies Created

Viewing 15 posts - 2,596 through 2,610 (of 2,855 total)

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

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

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

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

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

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

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

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

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

  • RE: Alternating Cursors?

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

    bmg002 - Monday, April 10, 2017 4:26 PM

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

  • RE: XCOPY failing via xp_cmdshell

    angeloc - Thursday, April 6, 2017 5:46 PM

    Some of the replies here are spot on.

    $ admin shares can only be accessed by...

  • RE: DB restore stucks after recovery step

    I still think the most likely culprit is that you have 13K files to write to.  How many physical disks are you writing to?  I'd be willing to bet the...

  • RE: SQL Server DBA Certification

    Eric M Russell - Thursday, April 6, 2017 6:47 AM

    bmg002 - Wednesday, April 5, 2017 3:08 PM

  • RE: Index and or constraint

    It might not be a bad idea to turn this project of "add a column" into a full re-write of all of the software to utilize a better database design?...

Viewing 15 posts - 2,596 through 2,610 (of 2,855 total)