Recent content by plange

whew-- found this and it worked: http://www.eggheadcafe.com/community/aspnet/9/4710/hmmmyou-can-try-this.aspx

I just did a major stupid thing-- I thought I could just delete a _log.ldf file if it was too big and so stopped SQL and deleted it-- Of course DB didn't work when I restarted SQL. I renamed the original .mdf file, detached the database, recreated the database and performed a restore, but the...

Thanks Monksnake-- that was a big part of the problem! (the other was the screwy way I was doing the startnum, once I made that eq the array length it worked!)

I have the following function, which is called when a link is clicked on the page (there will be a list of names, each of which calls this function). I thought I wrote it so that if the second one is clicked it will add to the array, but it keeps replacing it. What am I doing wrong...

Thanks, unfortunately no, it's our own on our own box. It was a new install and there's just something that is not the same as our old DB on our old server because this never happened before.....

Does anyone have any idea why this keeps resetting?

It seems to be resetting every time I restart......

Thanks, I checked that out and did this: SELECT OBJECTPROPERTY(OBJECT_ID('ET_Pages'),'TableTextInRowLimit') and it returned a 0 which means textinrow is not turned on right?

This is still happening. I don't know it's reset until a client calls complaining their content is cut off.....

okay, this is weird..... it keeps resetting itself randomly to 64512

Okay, in case anyone else has this issue, here is the solution: Apparently there is an upper limit to this textsize-- I put in 645120 and it took and displayed in QA that it was set at that, but when I changed it to 524288 it worked.

Okay, have the truncation at insert fixed, but still have a problem with display. The full data is definitely in the database (I inserted twice what was in there and did the datalength query and its value doubled) but yet, it still only displays part of it despite my increasing the textsize per...

Okay, am finding out it's getting truncated on INSERT too, and discovered that the default setting is 65536 (64K) and that to increase it (which you can increase up to 2GB) you have to do this: sp_configure 'max text repl size', 131072 GO RECONFIGURE WITH OVERRIDE GO which will increase it to...

Thanks so much! You've put me on the right path.... ran the below SELECT @@TEXTSIZE AS 'Text Size' SET TEXTSIZE 645120 SELECT @@TEXTSIZE AS 'Text Size' and the original value was 64512, so I added the 0, but it's still not displaying. I did a DATALENGTH query on one of the ones that is cutting...

Not viewing it in the Query Analyzer, but in the output on the content on the website. The code hasn't changed, etc. and I remember this happening before and that we had to make some change to the setting for SQL but for the life of me I can't remember what....