• David Hutcheson (6/14/2011)


    "SSMS does - just occasionally - report an error where none exists."

    Really? This is the fifth most common SQL Server error? After using SQL Server pretty much every day for the best part of ten years I have never seen this.

    A transport level error has occurred......

    This comes up if the server has disconnected the client's session, maybe the server/service was rebooted or someone killed the connection in activity monitor.

    so yes, you do occasionally get 'random' errors that go away if you hit execute a second time. I get it regularly because I leave ssms open on my pc and my pc switched on pretty much 24/7

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------