I have a SQL Server 2000 store procedure that reads and insert data to an AS400. Suddenly it stopped working properly. On the Query analyzer: if I call it using exec sp_name, it runs infinitely; if I run the store procedure code it runs properly. Any idea why when it is executed as a store procedure runs infinitely? Another thing is I cannot drop or alter it.