A pint! Oh My! Phew! Ouch! That's a big bottle! Hehe.
Have a great Day!
-----Original Message-----
From: Richard Tabar
[mailto:mssqldba-ezmlmshield-x90706546.[Email address protected]
Sent: Tuesday, March 27, 2007 11:43 AM
To: LazyDBA Discussion
Subject: RE: How can this be?
Have a Pint for me then ;)
-----Original Message-----
From: Carol Green
[mailto:mssqldba-ezmlmshield-x99906380.[Email address protected]
Sent: Tuesday, March 27, 2007 11:39 AM
To: LazyDBA Discussion
Subject: RE: How can this be?
Here - woohoo!
-----Original Message-----
From: Richard Tabar
[mailto:mssqldba-ezmlmshield-x25358680.[Email address protected]
Sent: 27 March 2007 16:35
To: LazyDBA Discussion
Subject: RE: How can this be?
It's also 5 O'clock somewhere :)
-----Original Message-----
From: Chris
[mailto:mssqldba-ezmlmshield-x27425440.[Email address protected]
Sent: Tuesday, March 27, 2007 11:30 AM
To: LazyDBA Discussion
Subject: RE: How can this be?
Almost Friday?????
-----Original Message-----
From: Edwards Ed
[mailto:mssqldba-ezmlmshield-x22572503.[Email address protected]
Sent: Tuesday, March 27, 2007 8:22 AM
To: LazyDBA Discussion
Subject: RE: How can this be?
Mike,
You have my permission to say "Oh My! Phew!"! hehe.
Hot fun in the summer time! Hehe. It's almost Fridayyyyyyyy!
Have a great Day!
Please take a few minutes to provide feedback on the quality of service
you received from our staff. The Department of Education values your
feedback as a customer. Commissioner of Education Jeanine Blomberg is
committed to continuously assessing and improving the level and quality
of services provided to you.Simply use the link below. Thank you in
advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: Michael Sexton (US-IT Contractor)
[mailto:mssqldba-ezmlmshield-x95121589.[Email address protected]
Sent: Tuesday, March 27, 2007 11:13 AM
To: LazyDBA Discussion
Subject: RE: How can this be?
Thanks
I have seen developers (Do I get to put in the "Oh My! Phew"?) do just
what you say below and have seen the warning. In the past I have fixed
this so the fields are a reasonable size despite the "Don't worry 'bout
it" protestations to the contrary. I had assumed that SQL Server would
throw an error on the insert, rather then accept a row > 8K. Guess not.
But why should an alter column statement blow up? My understanding is
that SQL is just checking to make sure the existing data meets the new
XML schema, so it should not be doing any I/O at all.
Thanks
Mike
-----Original Message-----
From: Gordon Rayburn [mailto:mssqldba-ezmlmshield-x79397043.[Email
address protected]
Sent: Monday, March 26, 2007 4:47 PM
To: LazyDBA Discussion
Subject: RE: How can this be?
Actually, SQL Server will happily insert [and truncate] data over the
rowsize limit (which is what you're hitting), but it does so while
warning you that it is going to truncate data. Sounds like someone
ignored the initial warning from the server when the table was created
and went about inserting data as if nothing was wrong (I've seen it
before!).
Try creating a table with several varchar(4000) columns, you'll get a
warning about the truncation, but the table gets created, and your
inserted data gets truncated at the 8030 limit...
-----Original Message-----
From: Michael Sexton (US-IT Contractor)
[mailto:mssqldba-ezmlmshield-x5262811.[Email address protected]
Sent: Monday, March 26, 2007 2:23 PM
To: LazyDBA Discussion
Subject: How can this be?
Hello All
I have a table in SQL 2005 that holds XML data bound to a particular
schema. The BizTalk programmers, in their infinite wisdom, have decided
they want to add a single optional element to this schema.
In order to accomplish this, I need to set the schema definition of the
column to NULL with the following:
alter table dbo.whatever
alter column xml_whatever xml NULL;
which gives the following error:
Msg 511, Level 16, State 1, Line 4
Cannot create a row of size 8083 which is greater than the allowable
maximum of 8060. The statement has been terminated.
So, as I am only working with data that is already on the table, how is
it possible to get this error? The data could not possibly get there if
the row size was this big to begin with.
Any clue for the clueless?
Mike
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
------------------------------------------------------------------------
------
NOTICE OF CONFIDENTIALITY
The information contained in this communication and any accompanying
document(s) is proprietary and confidential and is intended solely for
the above-named individual or entity. If you are not the intended
receiver, recipient or entity, you are advised that any distribution,
copying, disclosure or communication of this email is strictly
prohibited. If you have received this email in error, please contact me
at the telephone number listed above or 858.716.1500.
========================================================================
======
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
--
This message has been scanned for viruses and dangerous content by
MailScanner, and is believed to be clean.
Douglas County, Oregon
www.co.douglas.or.us
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page