Search results for query: *

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

Help... someone else (who is no longer here) configured our old database (MS SQL 2K) to allow people to post larger chunks in ntext columns (as it was getting cut off) and we just ported that database to a new server and now a lot of our ntext data is truncated. I don't know what he did, but I...

thanks-- that led me in the right direction-- I had used one, but when I imported the registry the old one was there too-- I took out the new one and tried the old one and am able to do this: -I can open Imail Client and use a virtual domain I have set up and send mail to an outside domain and...

Trying to take a load off of my main server and moving Imail to its own server. I installed same version on new server, copied over contents of IMail folder, and exported the Domains key in regedit, as well as the SMTPD32 (changed the paths) and all "seems" okay, but wanted to test by opening...

I've revised the js but still no go: function checkQuestions(which) { // require at least one radio button be selected per question isValid = false; for (i = 0; i < which.length; i++) { if (which.element[i].checked) { isValid = true; } else { isValid = false; break; } } if...

HELP! I have a survey where the questions displayed on the site are dynamically pulled from a database and each question has a series of radio buttons. Each question needs to be answered and I thought this would do the trick but it isn't: <!-- function checkQuestions(which) { // require at...