How to make SQL server non-responsive

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

    Zhigang

  • 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

  • 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