the application calls thestored procedures. its a general function to get the recordset so i cant set a commandtimeout because it timeout the other queries that need to run first. need the particular sp itself to timeout somehow.
I need to do the same thing (i.e. force a timeout to test some error handling code), but from SSMS. I've tried going into Tools > Options > Query Execution and setting a timeout of 3 seconds. Then I tred running a query with WAITFOR DELAY '000:00:10'. But the query doesn't timeout. What else do I need to do?