question

ashikanta avatar image
ashikanta asked

Transaction time-out after

Hello Friends,

Just wanted to know the parameter in sql 2000 which is equivalent to "Transaction time-out after" (default 30 sec) in sql 2005 server.

Thanks & Regards, Sashikanta Mishra.

timeout-expired
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Matt Whitfield avatar image Matt Whitfield ♦♦ commented ·
Can you explain a bit more? Are you talking about a parameter in Query Analyzer in 2000 or Enterprise Manager? Or are you talking about a parameter in your code?
0 Likes 0 ·
Fatherjack avatar image Fatherjack ♦♦ commented ·
I think the reference is to the Tools | Options | Query Execution | SQL Server setting in SSMS 2005? I dont remember there being a similar setting in QA... Also 30s isnt default in 2005.
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.