You have to set the timeout in SQL Server configuration properties.
Certified VB6, SQL 7 and ASP developer
Home Page: http://partha.tripod.com
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!