debug timeout procedure - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

debug timeout procedure

Author

Topic

desikankannan
Posting Yak Master

152 Posts

Posted - 2008-02-11 : 00:36:04

Hi,
we are working with .net with sql and we try to debug the stored procedure it working good but after a minute it say timeout expired.
my questions is that how to set time for debugg i want set the time 20mints.

Regards
Kannan.D

Desikankannan

georgev
Posting Yak Master

122 Posts

Posted - 2008-02-15 : 08:36:53

run
[CODE]
EXEC sp_configure
[/CODE]
And look for query wait.
More information on this procedure here http://doc.ddart.net/mssql/sql70/sp_ca-cz_28.htm

George
<3Engaged!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-02-15 : 08:53:16

Did you ran stored procedure in query analyser & checked how long it took?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources