turn off warning messages

[vlitim]

I am getting a warning message below which I need to turn off.

Warning: The table '#tempItems' has been created but its maximum row size (15290) 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.

cheers

Tim

 

[vongrunt]

If data cannot exceed 8060 bytes, then make some columns in #tempItems smaller.

If data can exceed 8060 bytes then this warning makes sense and turning it off is not a good idea.

'Nuff said?

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[vlitim]

I want to turn it off as I know its a problem but I will never be updating more that 8060 bytes at any one time.

 

[SQLDenis]

Take a look at SET ANSI_WARNINGS OFF
I am not sure if it will help you
It does work for the following
(When ON, if null values appear in aggregate functions (such as SUM, AVG, MAX, MIN, STDEV, STDEVP, VAR, VARP, or COUNT) a warning message is generated. When OFF, no warning is issued.
)


“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/