• Steve Jones - SSC Editor - Friday, February 8, 2019 7:05 AM

    The question asks how many rows are returned from sys.objects. There is only 1. This is accurate and correct.

    As to why or where you would use this, I'm not sure. It's a security hole and a potential source of problems with no real benefit. This question was created as I was unaware of this until recently, but others have used it. If you came upon this, my advice would be to remove this from your system and force people to update code for things like GetOne2, GetOne3, etc.

    I stand corrected
    😎