As we all know, there are many ways to skin the same cat, as shown here as well.

If we should go the 'short route', the minimum needed is just to...

AFAIK, timestamp has never been intended to be an 'incementor', but rather a 'uniqifier'.. In my version of BOL (2k updated) the wording is slightly different:

'The value in the...

You can't use timestamp for that purpose.

The timestamp value is a random unique binary value, you cannot assume that there is any particular sequence to all generated timestamps from a...

If I understood the shipment-carton tables right, this shouldn't be more than straight join with a not exists clause to get this list...?

create table #shipment ( sId int...

bcp isn't by far T-SQL either, it's a commandline exe just like isql and osql. You do need to use xp_cmdshell for all of these if you want to exec...

I think we need a more generic explanation in simple words to what the real problem is - that is, what is the purpose - instead of the specifics of 'how...

Eh..?

You mean like 'how do I turn a tick in my box in the windowsform' type thing..?

Sorry, but I'm lost to what your...

The complete errormessage will always be sent to the client, it's not even possible in some cases to trap the errormessage in your T-SQL code.

How it is handled and displayed...

You need to use an update statement in order to update

For the above result,

UPDATE emp

SET    fileSent = 1

WHERE  Inactive = 0

AND   ...

Hmm... but you do have all the required data for each recipient avaliable in table(s), right?

I can't really see why a 3rd party tool would be necessary. It shouldn't take...

Here's a few places with some very insightful information. (and don't forget BOL, your no#1 source of info)

How to Interact with SQL Server's

I thought about the typo thesis for the ranges as well, but that broke with the wanted results of example 2..

/Kenneth

The question still remains to be asked.. What problem are you trying to solve? I don't think you'll get much help if we have to guess what you want.

The examples...

Matty,

you need to tell us what errors you get. 'Not working' isn't very much to go on.

However, I didn't have any problems doing the below (minor changes to logical names...

This doesn't seem right. Are you sure this is the complete commands, and the right resultset from the restore?

Since the restore is specifying another dbname than the one backed up,...