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 IamaSherpa 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
  • Order by date
  1. KWade

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

    Thanks nigelrivett, Sorry I haven't responded but I just haven't had time to look at this until now. I was able to use some of your code from your "Find Gaps in Sequence" page. Here is what I came up with. There may be a more elegant solution but this seems to be working. Thanks, KWade --...
  2. 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...
  3. KWade

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

    shaddow, Thanks for your posts.
  4. KWade

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

    shaddow, Are you saying save all my form variables as session variables? I don't think I can do that. I have some fields that contain large amounts of data and several users using the page. I don't think I want to be storing all that data in session variables. I thought your example was...
  5. KWade

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

    Thanks shaddow, I tried using the saveHistory (found more info on MS ) but I still couldn't get it to work. I see what you're doing with the second post but how would you go about checking or using the session variables? With a <body onload= >? Thanks,
  6. 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...
  7. 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 ===========...
  8. KWade

    getting rid of tasks

    Hi Jay, Thanks for you help. Here is some more info. Vision is a Deltek product for Accounting and Marketing. It's SQL Server 2000 databases with an ASP front end (lucky me! I'm new to both). The database GTest is a database that I've restored from a different databases's backup from this...
  9. KWade

    getting rid of tasks

    Thanks Jay, I was able to find the the information through Enterprise Manager. The application name of 3 of the process are listed as Deltek Vision(default) and 1 process is listed as Deltek Vision(Process Server). I tried to kill the processes but they wouldn't kill. Any other suggestions...
  10. KWade

    getting rid of tasks

    Hi, When I do the sp_who command that is all the information for each spid that displays. Isn't GTest (under the dbname column) the database that it is attached to? As for &quot;program name&quot;, there isn't anything listed when you issue sp_who. If there is another way to find this...
  11. 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...
  12. KWade

    Find who is using database

    Thanks, I've tried to kill these tasks but they either aren't going away or else they are coming back. The login name is the the same as used to login into the server not a normal user. Thanks, Keith
  13. KWade

    Find who is using database

    Thanks, I was able to find the process assocociated with the database that I wanted to restore but I was not able to KILL all the processes. There are 4 processes attached to my database. This is a test database that only I was using Friday. The 4 processes all say &quot;awaiting...
  14. KWade

    Find who is using database

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

Part and Inventory Search

Back
Top