These links should help you...

http://support.microsoft.com/default.aspx?scid=kb;%5BLN%5D;296769

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=148030#bm148031

What is the error? 

Also, it helps if you post ALL the code, so we don't assume the error is because of missing DECLARE @varhd1  statements, or due to datatype...

When's the last time you ran sp_updatestats?

I use Red gate's SQL Compare software for this.  It's got all of what you need.

http://www.red-gate.com/products/SQL_Compare/index.htm

You can get this info from just looking at the proc sp_MS_marksystemobject.  It'll show the updates made, and then you can reverse those actions.

ditto.  I agree with RGR. Make sure you test this before you do it in your production environment. 

well, you may be able to just update the status column in sysobjects.  Now, what value to use when you update it, is a good question.

You could create an exact copy of the table, insert all the data from the "system" table and then drop the system table.

No need for a reply, this issue was figured out.  It was because one of our DBAs enabled 4 separate trace flags that Microsoft had asked us to enable to...

DBCC FREEPROCCACHE 

Also, in regards to Updates, if you specified cascading updates, this will obviously have an effect on your data.

These tools are common in the industry.  They are commonly referred to as SQL DBAs and SQL Developers.  Highly qualified ones can produce optimal SQL after taking a small amount...

I do have deadlines.  Unlike some folks http://www.sqlservercentral.com/forums/userinfo.aspx?id=147923 who can just spend all day surfing the net and telling people how they are not following rules of a online message...

I am not going to take the time to supply all that.  I know execution plans are good.  Sometimes you just gotta say $#%@ it.

   My bag of tricks has been on empty for a while with this issue.