Paul: I get it now. Thanks for the help. I appreciate it. Andy
----- Original Message ----- From: Paul Robinson [mailto:[EMAIL PROTECTED] Sent: 1/21/2005 9:18:09 AM To: [email protected] Subject: Re: [ASP] SQL Error - Maximum Row Size To give you an example of what I mean - this temp table will have a row size of 775 CREATE TABLE #SelectReport (ReqHeader varchar(100), ReqType varchar(50), Status varchar(25), BURequestor varchar(100), CSInitiator varchar(100), PrimeAss varchar(100) null, SecAss varchar(100) null, FuncArea varchar(100), SubArea varchar(100)) ----- Original Message ----- From: "Paul Robinson" To: Sent: Friday, January 21, 2005 2:02 PM Subject: Re: [ASP] SQL Error - Maximum Row Size > >I believe the error is caused because the total size of the fields in a row > of your temp table = 9414. You have to limit the total size to 8060 or less. > >----- Original Message ----- >From: "Andy and Kim Mills" >To: >Sent: Friday, January 21, 2005 1:52 PM > Subject: [ASP] SQL Error - Maximum Row Size > > >> >>Hello Everyone: > > >>I have been charged with looking into a loss of data. When I go into the > Stored Procedure on SQL Server and step through the code: I am getting the > folloring error: > > >>Warning: The table 'tempAlbum' has been created but its maximum row size > (9414) 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. > > >>This stored Procedure creates a TEMP table and inserts values into it. > However: as you will notice, it is exceeding the maximum row size by a > significant amount: hence we are losing data when the INSERT happens, as > all data after byte 8060 is being set to NULL. > > >>My question is: how do I correct this to allow all the data to be > inserted? I have never seen this error before, so not sure exactly how to > fix it. I guess I could alter the SP to insert directly into the table > itself, but this would be a MAJOR re-write and I would like to avoid that if > possible. > > >>Thanks for any help > >Andy > > >> >> >>--------------------------------------------------------------------- >>Home : >>[http://groups.yahoo.com/group/active-server-pages]http://groups.yahoo.com/group/active-server-pages >>--------------------------------------------------------------------- > >Post : [email protected] > >Subscribe : [EMAIL PROTECTED] > >Unsubscribe: [EMAIL PROTECTED] > >--------------------------------------------------------------------- >>Yahoo! Groups Links > > >> >> >> >> >> >> > > > >--------------------------------------------------------------------- >Home : >[http://groups.yahoo.com/group/active-server-pages]http://groups.yahoo.com/group/active-server-pages >--------------------------------------------------------------------- > Post : [email protected] > Subscribe : [EMAIL PROTECTED] > Unsubscribe: [EMAIL PROTECTED] > --------------------------------------------------------------------- >Yahoo! Groups Links > > > > > > > --------------------------------------------------------------------- Home : [http://groups.yahoo.com/group/active-server-pages]http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Sponsor ADVERTISEMENT [http://us.ard.yahoo.com/SIG=129rh57an/M=297844.5692940.6932969.3356155/D=groups/S=1705115381:HM/EXP=1106403508/A=2533537/R=0/SIG=10v7of2am/*http://www.target.com/careers] -------------------------------------------------------------------------------- Yahoo! Groups Links � To visit your group on the web, go to: [http://groups.yahoo.com/group/active-server-pages/] http://groups.yahoo.com/group/active-server-pages/ To unsubscribe from this group, send an email to: [mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the [http://docs.yahoo.com/info/terms/]Yahoo! Terms of Service . [Non-text portions of this message have been removed] --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
