I also faced similar problem where I was using GUI to alter a column in my table. Since this table has a VarBinary(Max) column which stores large documents, I...

Hi Amit,

• The system (W2K3) server is accessible.
• Proper network connection is in place.
• The user has administrative rights
• The user is using Windows Authentication to access the database server.
• Database name being used is...

Actually I did a small mistake in my original question which took the whole discussion to a different direction.  As Steve has noticed I wanted to...

I thank every one who tried to answer the question, especially Antares686 detailed answer is very knowledgable and clears the concept of space taken by null varchar.

I tried as suggested by you and it worked.  Frankly speaking, the Transform elipse as mentioned in your reply, is normally hidden too far right on the form and I...

I was never truncating a table rather used to delete it with the understanding that since Export DTS Wizard creates a new table why should I bother to truncate it.

Now...

I agree that my perception was wrong.  It worked the way you suggested.

I thank you as well as other members of the forum who helped me to

Hello Kelvin,

INSERT INTO TS_Deleted

SELECT * ...

though is very simple but it forces me to have all columns in the target table that exist in the original table.  In my case...

Thanks for yoru help. I am using SQL ver. 2000.

In fact the first code was also OK.  By mistake another Trigger was also active which was generating the error message. ...

I tried your code as shown below but now I am getting an error message when I delete a record in the original table:

"Insert Error: Column name or number...