October 24, 2003 at 10:32 am
Using SQL server 2000.
I'm trying to increase the size of a varchar column from 4096 to 6000 in a database with about 3000 rows. I get the following error:
Error: 1780, Severity: 20, State: 0
Could not find column ID 15 in syscolumns for object ID 892582268 in database ID 7
The column is not indexed. The database had been enabled for replication, but there were no published articles. I ran sp_removedbreplication and I still get the same error.
I've run DBCC CHECKDB and CHECKCATALOG on both the user and master databases with no errors reported.
Any ideas?
October 24, 2003 at 10:38 am
Just a though, if you can't increase the size, have you try to re-name the table and recreate the same name table with that size and then import the data back?
mom
October 24, 2003 at 12:18 pm
Have you check the total size ( per row ) of your table?
6000 is pretty big. Considering a maximum of 8060 per row you have theoretically 2060 left and I don't know what other columns you may have? but this is just a shot in the dark
* Noel
October 24, 2003 at 12:44 pm
That was a good thought but the table doesn't approach the maximum row size.
I can't even increase the size of the coulumn by 1.
October 24, 2003 at 5:22 pm
Looks like confusion in the syscolumns table. I would take mom's advice and just rename, create new, copy the data.
Guarddata-
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply