Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. plange

    can I restore a DB if I only have the mdf file? HELP!

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

    can I restore a DB if I only have the mdf file? HELP!

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

    populating arrays

    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!)
  4. plange

    populating arrays

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

    Increasing size of row/DB?

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

    Increasing size of row/DB?

    Does anyone have any idea why this keeps resetting?
  7. plange

    Increasing size of row/DB?

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

    Increasing size of row/DB?

    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?
  9. plange

    Increasing size of row/DB?

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

    Increasing size of row/DB?

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

    Increasing size of row/DB?

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

    Increasing size of row/DB?

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

    Increasing size of row/DB?

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

    Increasing size of row/DB?

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

    Increasing size of row/DB?

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

    Increasing size of row/DB?

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

    migrating to new server

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

    migrating to new server

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

    Dynamic radio button validation-- need help urgently

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

    Dynamic radio button validation-- need help urgently

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

Part and Inventory Search

Back
Top