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

    Stored procedure question

    Hi all, I want to run a stored procedure from th emaster database. This stored procedure creates database devices, backup devices, etc etc, this all works. However it should also create a bunch of stored procedures, defaults and tables. I can create the tables building the variable database...
  2. uncLez

    SQL - Backup Procedure

    Hi, I am no SQL admin GURU but I do have some experience on the subject. Your last questions first :D You can either backup to different tapes, or have the DLT change tape whenever it is full, both options are perfectly usable. However, I myself would prefer to have dumps on disk in the...
  3. uncLez

    Trunc log in sql 6.5

    I'll look into it and test some scripts, thanx very much so far!
  4. uncLez

    Trunc log in sql 6.5

    Sorry, just to prevent any misunderstanding, I am talking about the transaction log here...
  5. uncLez

    Trunc log in sql 6.5

    Hi all, I am having trouble finding a solution for the following. In SQL 6.5 we would like to schedule a log trunc right after we have a scheduled backup of our database, since this particular database has vast amounts of transfers and sometimes exceeds the log size. Is there a way in SQL...
  6. uncLez

    SQL error... (idle connections)

    Yeah, sorry, I forgot to include that. I always close connections like this: connection.close SET connection = NOTHING So that should not be the problem... It is weird, cause the connection object is really gone, I tested that with some scripts, but the database keeps the connection wide...
  7. uncLez

    AWAITING COMMAND idle connections.

    Ok, thanx for your help so far!
  8. uncLez

    AWAITING COMMAND idle connections.

    I forgot to mention, I always use: conn.Close SET conn = NOTHING when I close the object, so I more or less already do as you propose... Should I use NULL or NOTHING here? I mean, is there a chance that this would lead to a different result?
  9. uncLez

    ONE QUERY OR TWO - URGENT!!

    I'm no guru, so there might pop up some better solutions, but I would use the cursor, in a loop fetch your po-no's and have your StorProc build a string using CAST and string concatenation, then when reaching the end of your cursor, pass that string onto the INSERT statement...
  10. uncLez

    SQL error... (idle connections)

    Hi all, I posted this on the SQL Server forum as well, hope you guys don't mind, but this seemed a logical place to also post my question... I am having this (imho weird) problem on MS SQL Server 6.5 (yeah, I know, we need to upgrade... BAD :p) which is as follows... I am running Queries...
  11. uncLez

    AWAITING COMMAND idle connections.

    Hi all, I am having this (imho weird) problem on MS SQL Server 6.5 (yeah, I know, we need to upgrade... BAD :p) which is as follows... I am running Queries against various databases from ASP scripts. I close my connection right away whenever I don't need it anymore. (Using the...
  12. uncLez

    Java Script Menu over an Iframe in older browers

    Hi all, I have a drop-down menu in Javascript which SHOULD work for loads of browers, BUT... In Versions of IE older than 5.5 and in Netscape versions, the menu falls BEHIND an iframe I use, in IE 5.5 and 6 it shows up the right way... Is there a way to force the divs to show up over the...
  13. uncLez

    onCLick status bar message

    I already tried that... That does not fix the problem :/
  14. uncLez

    Can you see the error?

    Hmm, I did not find it :p But I think you would need to use another way to do that though... The ParseInt obviously can not do that for you. You would need like a ParseLong or something :p Don't know if it exists though...
  15. uncLez

    document.write form validation of Enter Key

    can you show the relevant code?
  16. uncLez

    Can you see the error?

    So like... without wanting to be a jackass... What page are you referring to? :p I thin kyou forgot to include a link to the page that actually produces the error?
  17. uncLez

    onCLick status bar message

    Hi y'all :) I am fiddle-ing around with a drop-down menu in javascript and I would like to hide the status bar location messages, that the links show. I am currently using a MouseUp event to hide it, which works EXCEPT when the link is begin pressed. Using an onClick event next to the...
  18. uncLez

    Input Fields and Divs

    Hi all, a co-worker of mine is doing some work on a form that sometimes gets overlapped by a menu, which consists of div elements. Problem is, that the input fields (especially select boxes are nice [dazed]) show through the div... Which ofcourse looks very bad. Anybody got an idea on how to...
  19. uncLez

    string concatenation problem.

    For some reason I can't seem to flag your post as helpful or expert, but if I could I woulda. Thanx a bunch!
  20. uncLez

    string concatenation problem.

    That was exactly the problem. Thanx! \:-)/

Part and Inventory Search

Back
Top