Not sure I explained it well - you can execute the query and return it via DMO to a queryresults object. You dont HAVE to use ADO at all.

Andy

I think you have to use the attach option if there are more than 16. Otherwise sp_attach_db shoud do fine, you just keep passing it arguments.

Not totally on topic, but...

I actually do this quite a bit with in house utility apps - things built to automate a process that was too awkward for SQL alone. Definitely have to exercise...

Try sp_who or sp_who2 - both will show you the spid that is causing the blocking - its common to have to follow a chain where 1 blocks 2 blocks...

Maybe! Havent timed honestly, though you have to figure if you have indexes on the table that might add to a bit more time than just appending to the end...

I dont think you can get passwords from the login object in DMO, you can just set passwords. You can definitely run the query using the executeimmediate which will return...

Try just using executeimmediate. Once you start doing more than the simplest of queries you'll be better off using ADO for that part of it. Richer tools, returns a real...

Steve - you been writing spew again? I TOLD you to turn the humor checker on!

Andy

Try this, it suggests that the ado connection might still be busy when you're trying to access it:

http://groups.google.com/groups?threadm=%23NSG2y6WAHA.263%40cppssbbsa03&rnum=2&prev=/groups%3Fq%3DCannot%2Bcreate%2Bnew%2Bconnection%2Bbecause%2Bin%2Bmanual%2Bor%2Bdistributed%2Btransaction%2Bmode.%26selm%3D%2523NSG2y6WAHA.263%2540cppssbbsa03%26rnum%3D2

If you dim your connection using withevents you can probably see whats going...

Just remove the (16) - text is all you need for SQL to know what you mean, all text cols are treated the same regardless of size (more or less).

Andy

I agree with Paul's answer - right on the money! Syntax looks like this:

Insert Into tablearchive (field1, field2, etc) select field1, field2, etc from

sourcetable where readytoarchive=1

The key is that the...

I'd suggest VB6 for now. Tons and tons of discounted books, learning CD's, etc available, plus a wide pool of web sites, in house developers, etc to help you learn....

Havent done merge in a while - but doesnt it require a distributed transaction?

Andy

Thanks! Hope you'll continue to visit and participate.

Andy

No reason you couldnt create a user defined function to do the work. Should be fine to discourage casual snooping, just dont rely on it for anything more!

We've got an...