Recent content by uncLez

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

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

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

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

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

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

Ok, thanx for your help so far!

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?

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

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

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

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

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

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

can you show the relevant code?