Thx for the reply Gail Shaw. I was able to successfully completed the page restore with no impact to replication. This is the first occurance we had on this server...

Thank you all for your valuable feed back... Apologize for the delay in response.... I will make sure that from the next time I will post the code in a...

Thanks to everyone who replied to my post.... Feels good to be in the community where experts are ready to help out....

Regarding the issue i posted yesterday....i modified my cursor...

I am pretty sure that upgrading a 32bit SQL 2000 to 64bit SQL 2005 is not possible. I have tried that once and i failed. I am assuming it is...

I do not know about upgrading windows. But as far as SQL Server goes, i believe you will not be able to upgrade a 32 bit sql 2005 to 64...