Query Timing Out

[mdub51879]

I'm calling a stored procedure on SQL Server 2000 that takes 2 seconds to run in the query analyzer, but when called from ColdFusion (8,0,1,195765 on Windows 2k3), it times out. The time out is set to 30 seconds. Any ideas?  Thanks in advance.

[Dileep_NR]

Hi,

Could you please  give us the  code set that you are using

[Dan_Bracuk]

Step 1 - test your cf/mssql connection by running a very simple cfquery.