Regarding my previous queries I put across to the forum Joe Fawcett came up with a suggestion that I could create a new table of identical structure import the old data to the new table. I have been able to create a new table and I did the following:

Exec sp_dboptions ‘dbname’, ‘select into’, ‘true,

Then decided to copy the data across using the following
Select * into ServerNew From Server
Where 1 = 2
Go
I go the following error messages: There is already an object named ‘ServerNew’ in the Database.
All I wanted to do is copy the old data from Server table to ServerNew table. What have I done wrong here? Your help will be much appreciated. Thanks


CarlWalden

__________________
CarlWalden

I wish to express my gratitude profound to all those who have help me to sort out this problem and my special thanks goes to Joe Fawcett for his suggestion, I have done as he suggested and DTS the data across to the new table and the entire business is happy now. I am so proud to be part of this forum, once again thank you for your professionalisms.

Regards,
:D

CarlWalden