Thanks for your answer!

> its says input param mismatch for MyStoredProcedure
> So it's tleling you that the parameter you declare in MyStoredProcedure
> doesn't match the expected use inside the proc.

That could the the problem, but would i be able to compile the procedure when i first created it?

> maybe it's a time or date field mismatch - are you upgrading the server?

No, im just restoring the database on the same server but with a diferent name!

Luis Semedo Duarte