Suppressing Warning Messages
-
When I run the following statement in QA:
ALTER TABLE [Test] NOCHECK CONSTRAINT FK_SchoolTrans_SchoolCodes
it works fine, but I get the message:
Warning: The table 'SchoolTrans' has been created but its maximum row size (9719) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
SchoolTrans is not a table whose size I can change, and the ALTER statement shown is just one of about 700 that I'm running. I'd like to suppress this warning, so I didn't miss something I need to be concerned about. Is there a way to suppress this message, and if so, will it suppress other messages I want to see?
Thanks,
Mattie
-
Hm, given the example you've posted. Have you actually read the message? I'd say it's a fairly important and interesting one you really should be concerned about.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Frank,
You certainly would think so, but it's purchased software, and therefore out of my control. I intend to raise the issue at our next vendor meeting.
Mattie
-
Hm, you should really do so!
Well, actually I don't know of a way to suppress some messages and others not. Maybe someone else...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
This error message only indicates the "potential" to exceed the maximum record size. Var-Char/Binary columns are not always filled to maximum capacity therefore the total record length may not exceed the maximum.
PeteK
I have CDO. It's like OCD but all the letters are in alphabetical order... as they should be.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply