Dont worry about it people.  I sorted it out.

Hi Roust m,

Thank you very much for your input.  Yesterday I searched around and found some script which is similar to what you suggested and somehow, it worked (I...

Thank you guys, particulary Racosta.  Your method works.  I was able to take a table off (even in Enterprise) after dropping the subscription.  It makes sense that if the table...

You are correct Andy. The dude set up the database did not create Primary Key for the table. I created it and it went pass that stage. ...

Thanks guys

Please excuse me for being stupid but is the new account you refer to is SQL account or Windows account? I created a new SQL account with System &...

I did the attach method since the user is not an issue (using dbo user) and it works.

Thanks Markus. I found out when I did the upgrade installation. Anyway, I backed up the old SQL and had a fresh installation of SQL 2K. I...

Thanks for all the inputs people. Really appreciate. I should've been more cleared last time. I am setting up a new server and trying to restore database...