We have noticed that our SYS_SPROC_VERSION is different (8.00.178 vs 8.00.375 on an instance that doesn't have the same problem with a restore of the same database) from the rest...
We ran it via a VBScript just using ADO to connect to the database. Therefore eliminating the possibility of it being our COM object. It still timed out....
Stored procedure is being run with the same arguments in both App and Query Analyzer. Although the App times out with any arguments. We have tried a test...
Here is some new info. It happened again this morning and instead of stopping and starting SQL/Server, I did an Alter on the stored proc to refresh it and...