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 --------------------------------------------------------------------- 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/
