Thanks for your reply.

I am sure that nothing is running at the time of executing this procedure..

The procedure is taking some data from linked server and saving to local database.

I...

Hi

can you just tell me how can i change my coonnection time property in my procedure.

please che ck my procedure.

SET QUOTED_IDENTIFIER OFF

GO

SET ANSI_NULLS ON

GO

ALTER ...

There is no job running while i am trying to run the said procedure.

It is taking around one minut for running in query analyzer.

This is the command i am using...