Can't recommend a product, but David Poole wrote an article on this topic recently, which you might find useful.

http://www.sqlservercentral.com/columnists/dpoole/dealingwithaddresses.asp

Maybe you could commission him for a nice bespoke number...

Sorry .. I see you reformulated your question slightly. I still reckon that Andy's solution was good though.

If you want to restrict running the job to certain users, it...

I think you already posted this under:

"Job execution from asp page"

and a good answer was given.

"Insert a row into a table, have your job poll that table, when it finds...

Well done on completing what must have been a very difficult task.

I hope it is a great success.

quote:

---

In the case of my client they have chosen Barclays bank so this means that all credit card details are handled by...

Steve, I agree with you *in priniciple*, especially if you have come across security

bug by chance -- although I don't think I can match your humility 🙂

However, I found Brian's...

>>(hacker) ..It used to be a revered term.

Still is where I'm standing 🙂

>>It's actually a question of motive:

>>Security Researcher - looks for

>> vulnerabilities, is generally responsible

>> about reporting them to...

If you mean execute a VB DTS package from an ASP page then you could compile the VB DTS package as a dll, and then reference and execute it from...

not an ideal solution, but a more long winded approach would be:

--create a new, empty table copied from the original table structure

--add the identity field to this new table

--copy all...

You might want to

a) copy the tables (schema+data) to a temp database (maybe use DTS)

b) back that temp database up

c) send the .bak file to your production servers

d) restore...

I think guarddata has this wrapped up. Nevertheless, I'll make a brief case for option number 1, which as I understand it is:

1) Do the selection query and insert...

Thanks for the replies and links. I was more of a BBC B man myself, but I'm sure all the machines you have mentioned were just as dear to your...

As long as you are committing in small batches - as Steve suggests - there may be some benefit to setting a recovery mode of "Simple" on your target database...

>>Essentially, from the time accident info is logged to the system, supervisor has

>> 24 hours to respond, safety officer has 48hours and deputy has

>>72 hours to respond.

That's not the...

>>With ADO, I guess that you are building the update statement on the client.

In DAO you can do something like this to a recordset object.

rst.edit

rst.fields("Name")="Bungle"

rst.fields("SexualOrientation")="n/a"

...

...

rst.update

I'm pretty sure it's the same...