Get table warnings?

Recently I added a varchar(8000) to a table through enterprise manager.
Everything went fine, no errors/warnings reported.
Thought I should script the change, got a warning through query analyzer
that row exceeded 8060. That I understand just fine.
Being no expert, I'm wondering how I can check my tables for warnings. DBCC
checktable reports nothing wrong on the table with row length > 8060.
I know I can manually check other tables for the row length, but I'm
concerned about other warnings I may have introduced.
Thanks,
MikeThough SQL Server lets you create a table with row size > 8060, you are
still limited by the size 8060. So, your table is just like any other table,
and SQL Server will not let you have a data row that exceeds that limit.
The DBCC commands you are talking about are mostly for checking database
consistency.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Mike Hildner" <mhildner@.afweb.com> wrote in message
news:uHy50X25DHA.1368@.TK2MSFTNGP10.phx.gbl...
Recently I added a varchar(8000) to a table through enterprise manager.
Everything went fine, no errors/warnings reported.
Thought I should script the change, got a warning through query analyzer
that row exceeded 8060. That I understand just fine.
Being no expert, I'm wondering how I can check my tables for warnings. DBCC
checktable reports nothing wrong on the table with row length > 8060.
I know I can manually check other tables for the row length, but I'm
concerned about other warnings I may have introduced.
Thanks,
Mike