Hi,
I've tested the code some minutes ago and it worked perfectly here. The item type is ok, so the old proc name might be the problem. Try putting dbo. in front of the old name. Maybe this helps. Are you sure have the old procedure on the server?
HTH,
Armin
>I tried i out but it is giving me an error saying "Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Error: The parameter @oldname is either ambiguous or the claimed @itemtype (OBJECT) was wrong."
>
>What am i doing wrong?