Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can't Delete Rows Or Columns

Status
Not open for further replies.

TheDrParker

Programmer
Nov 21, 2001
55
US
I have 2 tables with a Long Text columns and I think I stuffed more data than I was supposed to into them and now I can't delete the rows or the tables. I first put over 16,000 characters in the cells without realizing. Then created a new table and put only 16,000 characters, instead of 16K bytes, so I now have 2 tables I can't do anything with. Any help appreciated.
 
Have you tried TRUNCATE TABLE in query analyzer before trying to delete the table?

The Microsoft mascot is a butterfly.
A butterfly is a bug.
Think about it....
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top