Forum Replies Created

Viewing 9 posts - 1 through 9 (of 9 total)

  • RE: Download SQL patch Info

    Got it to work after rewriting the line that drops the import table if its ID is null, to dropping it if it exists. Select into can't work if it's...

  • RE: Download SQL patch Info

    bmg002 - Wednesday, July 5, 2017 11:08 AM

    christoffersen366 - Wednesday, July 5, 2017 8:16 AM

  • RE: Download SQL patch Info

    Nice project. But I'm not getting anything in the @html variable, the html file is empty. It can reach the site and I've tried another path without spaces with same...

  • RE: Five Useful SQL Server Management Practices

    Great list and I agree with all of it except for 5. Alerts might work well enough but I've heard it has issues so I think there are smarter ways,...

  • RE: Delaying Patches is Problematic

    roger.plowman - Tuesday, January 17, 2017 6:48 AM

    The problem with automatic patching over the long term is cruft. It also means bloat and...

  • RE: Simpsons' Paradox

    thisisfutile (1/10/2017)


    Very interesting. Thanks for posting. I hear this all the time..."Just the facts please, the facts don't lie." But, in reality, like you've demonstrated, while the...

  • RE: Taking backup of the databases to the Active server alone

    From SQL Server 2014 onward you can use "sys.fn_hadr_is_primary_replica" instead to determine if the current server is primary.

  • RE: SQLCMD to export data in txt file

    Very weird result. I have text all over the place in the textfile when it's a from a table I recently made, but it works fine with one of the...

  • RE: A google like search

    If you can't upload a script that actually works as intended, maybe you shouldn't upload. Maybe test first, then upload. You even write what part of the script is missing...

Viewing 9 posts - 1 through 9 (of 9 total)