Thanks,Bill
I am still using SQL Server 2000...I will see if I can find a corresponding configuration for setting the timeout.
Here is my code that I use for retrieving the data:
If the command timeout can be set, how do I do that from the BO?
Through a command:
'-- Never time outcmd.CommandTimeout = 0
'-- Set the parmscmd.Parameters.AddWithValue("@Parm1", 1).SqlDbType = SqlDbType.Int
'-- Set the command typecmd.CommandType = CommandType.StoredProcedure
'-- Execute the commandMe.ExecuteNonQuery(cmd)
Works great! Thanks a bunch. Oh...and the wait window...awefully nice feature!!
Now, I just need to work on getting that sproc to run faster than 90 seconds. It has several nested CASE statements that I think are gumming up the works. Not too sure how to simplify those conversions that are going on.
Happy Friday!Bill