Post reply

How to make SQL server non-responsive

  • August 22, 2001 at 2:26 pm

    #57531

    Does anyone know of a way to make SQL server non-responsive? I need to do this for testing purpose. Thanks.

    Zhigang

  • August 22, 2001 at 4:50 pm

    #417747

    Maybe pause the server? Not sure what result you need. Typically you'd just set a command/connection time out on your client app, then trap for the error if it does time out.

    Andy

    Andy
    Connect with me on LinkedIn

  • August 22, 2001 at 6:59 pm

    #417750

    The server pause should work. You can do it programmatically through DMO, using the server object and its "pause" and "continue" methods.

    Sean

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

You must be logged in to reply to this topic. Login to reply