Thanks for the help Brian.

Thanks for help.

Windows 2000 Adv server SP3. MDAC 2.6. Network library is TCP/IP and Named Pipe. SQL service and sql agent service runs unde domain account.

Thanks for your help.

I look at the Application and system log of the server but couldnot find any errors that will help.

Thanks

THat was SQL Agent Log. Here's the SP_Configure

ame ...

Is ther any formula that will help me calculating the log size?.

Thanks

Thanks for your help.

Thanks Matthew Burr. I tried the Dynamic SQL approch and it took 17 sce. to run the SP.

Any one has any other idea?.

Manesh

I did try with constant values assigned to variables inside the SP and run in 5 sec. Looks like I ave Same issue you reffering. Any solution?

When I am running the SP, I am passing arguments to sp. Thru QA I am assining that values to variables and leave the same T-sql on QA as is...

Thanks. I already tried recompiling SP before but same result. there is on data or table changes. I restored that database to another server.

Thanks for your help. Select 1/0 followed by return statement did work.

Thanks Katracvax. I drop the index and recreated.

Now both servers has same table size.