Okay, this is very strange...
I was attempting an insert into a table. The insert fails because the value I'm inserting is too long for, say Field1. The string I was inserting into Field1 was 55 characters long. I did sp_help [TableName] to see the length of Field1 and it said it was varchar(100). Hummm….
So, I run sp_help again just to make sure I'm not delirious, and sure enough it says the length is 100. I do: select * from syscolumns where name = Field1 and the length listed in syscolumns is also 100. Then I look at the table design in Enterprise Manager and the field length says 50.
This table has not been altered recently. Anybody know why the system tables are reporting different attributes values than are in the table?
Do I need to run some sort of statistics to update the system tables?
Has anybody found similar inconsistencies?
If anybody knows why this is happening, or how I can sync the system tables up, please let me know!
Thank you!
-MK
I was attempting an insert into a table. The insert fails because the value I'm inserting is too long for, say Field1. The string I was inserting into Field1 was 55 characters long. I did sp_help [TableName] to see the length of Field1 and it said it was varchar(100). Hummm….
So, I run sp_help again just to make sure I'm not delirious, and sure enough it says the length is 100. I do: select * from syscolumns where name = Field1 and the length listed in syscolumns is also 100. Then I look at the table design in Enterprise Manager and the field length says 50.
This table has not been altered recently. Anybody know why the system tables are reporting different attributes values than are in the table?
Do I need to run some sort of statistics to update the system tables?
Has anybody found similar inconsistencies?
If anybody knows why this is happening, or how I can sync the system tables up, please let me know!
Thank you!
-MK