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 bkrike 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: *

  • Users: KWade
  • Content: Threads
  • Order by date
  1. KWade

    Need a Query for finding the Next available number from a set.

    Hi all. I have a question that I'd like to get some help on. I have a table with a column (ProjectNumber) that contains something similar to the following: 04910010 04910020 04910030 04910050 04910100 04910110 04910120 04910500 etc... I would like to find the next available number which is...
  2. KWade

    history.back() or .go() and dynamic form fields

    Hi all, I am trying to use history.back() to get back to my previous page but the page comes up with empty form fields. The page I'm trying to get to has a form with several text input fields. I have a selection box that determines the value of another text field. When a user selects and...
  3. KWade

    Conditional dropdown boxes and reading from SQL Server

    Hi, Here's my problem. I have an ASP page using VBScript and JavaScript and reading SQL Server 2000 database. I want to display client and contact information on my webpage based on which 1)Client is selected and then 2) which contact for that client is selected. SELECTION 1 ===========...
  4. KWade

    getting rid of tasks

    Hi When I issue sp_who I get the following: (titles abbrev.) spid status login hostname DB Command 59 0 sleeping sa GLITAS04 0 GTest AWAITING COMMAND 62 0 sleeping sa GLITAS04 0 GTest AWAITING COMMAND 71 0 sleeping sa GLITAS04 0 GTest AWAITING COMMAND 78 0...
  5. KWade

    Find who is using database

    I am new to SQL Server. I am trying to restore a database but I get the message "Exclusive access could not be obtained because the database is in use. RESTORE DATABASE is terminating abnormally" Is there a way to display who is using the database? or to force everyone off? Thanks...

Part and Inventory Search

Back
Top