Group, I have a process that archives from one database to the another. I have a step that checks for the number of connections before I start the process. However the process can take 10-15 minutes and it never fails, someone will connect to either of the databases in the middle of the processes.
Although I use SET MULTI OFF, when I disconnect from database 1 and connect to database 2, database 1 becomes available for connections because I am now in database 2. Anyone have any slick tricks to open a second connection with code so that with SET MULTI OFF I have the only connections allowed to the database and then shut down both connections after I am done? Jan
