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!

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

Recent content by k8277

  1. k8277

    Dynamic SQL - update with a double quote in my field

    The reason for the loop is because the actual code is not as simple as I made it seem.
  2. k8277

    Dynamic SQL - update with a double quote in my field

    Hello - I am building some dynamic sql and I have a problem with a field I am reading from a database that contains a double quote that I am then trying to include in some dynamic sql to update another table. Basically I have this problem: create a recordset by selecting * from table A loop...
  3. k8277

    Call stored procedure in another database

    I am stuck here. I have 3 databases, A, B and C. Databases A & B contain my data for two different locations. Database C contains my custom stored procedures and functions. I would like to be able to call a stored procedure which resides in database C from database A. I want the stored...
  4. k8277

    Display additional announcements

    Thanks, That does work, however it changes the formatting and turns the data into a list of items instead of the default announcement display. Is there anyway to have it not change it to a list format. We are including images in the body of the announcement and when I make your change, they...
  5. k8277

    Display additional announcements

    I am using WSS 3.0. With regard to the built in Announcement web part, I would like to display more than 5 current announcements at a time on the main page. Currently, it only displays the 5 newest announcements. Can this be increased, preferrably to display all that have not expired?
  6. k8277

    500 Internal Server error missing details from log file

    Chris, thanks. Why is it that sometimes the iis log file contains the problem (line number from the page and details), but not always?
  7. k8277

    500 Internal Server error missing details from log file

    IIS 6.0 Last week a page on my classic asp site started producing frequent 500 errors. The iis log file contains the error, however it is missing the detailed data of where the error occurred and why. It has the page and the 500 error, but doesn't tell me on what line and why the error...
  8. k8277

    Modify the new user welcome email

    How do you modify/customize the email message that is sent when you add a new user to your sharepooint site?
  9. k8277

    WSS v3 with Forms Authentication

    I have this up and running, but I need to know how to modify the forms login page. I am trying to use Sharepoint Designer 2007, but when I attempt to save the login.aspx file, it tells me there server must be running either Frontpage extensions or Sharepoint Services. What am I missing here...
  10. k8277

    WSS pushing content updates to subsites

    With WSS 2.0 is there a way to add content (ex. an announcement) to a site and then automatically have it update all of the subsites with the same addition?
  11. k8277

    Need to add a site template to the top level template list

    WSS 2.0 I saved a site as a template, so now I have a xx.stp file. I would like to include this template in the list that you get when you create a brand new top level site. How can this be done? Right now, I just see the default templates that Microsoft gives you out of the box. Thanks
  12. k8277

    Disaster Recovery - moving master db to new server and new partition

    I am creating some disaster recovery documentation and doing some testing. My problem is: On my production SQL server all of the sql data is located on drive E:\mssql\data\*.* and I am trying to restore all of the data to a new server on C:\mssql\data. I was able to restore the master db...
  13. k8277

    Out of Memory Error

    tsuji - I tried your demo code and yes it does produce the out of memory error. I guess I need to determine how the condition ** Ubound(xArray,2) = -1 ** comes about. Thanks for the help.
  14. k8277

    Out of Memory Error

    I have a line of code that is randomly giving users a problem: Redim yArray(3,Ubound(xArray,2)-1) In the IIS log file it gives me a 500 Out of Memory. The server has 2GB and pretty much runs with 1.3GB free. Other posts on the net have said this could be caused by two things in the second...
  15. k8277

    Http 500 Internal Server Error - how to find error details

    In looking at my post and the logs, I do have the page, I just need the full error message and the line #.

Part and Inventory Search

Back
Top