Hi Syed,

Thanks for the reply.Actually i am running the procedure using java-CallableStatement on SQLServer and the timeout is set in the java code.