There are a lot of good books out there but to maximize what you can get I would do the following. Find a couple of used book stores and go...

If you have not already done so take a look here at the following article.

http://www.sqlservercentral.com/columnists/jtravis/understandingthedifferencebetweenisnull.asp

But there are factors such as Connection explicitly turning off or that the server itself has...

A couple of ways but the way I use for simple situations like this is

SELECT t2.col

FROM t2

LEFT JOIN t1

ON t2.col = t1.col

WHERE t1.col is null

Left will...

DTSTaskExecResult is related to scripting.

For SQL code use RAISERROR with RETURN to force a failure message to the message pump.

Point blank a nonclustered index will always read more pages as oppossed to a clustered if there is a clustered index on the table as well.

The reason is the nonclustered...

What version of SQL are you running and what SP level? I seem to recall something like this with SQL 7 but was SPed with a fix. Have you tried...

Is this for a linked server? If so just open up the linked server and on the last tab you can turn data access on.

I assume you are refferring to a manual run inside the package design view or the package storage area. I have seen where Cancel is an issue here myself and...

There are many solutions to most problems and of course you can use a cursor in this case. However another option depending on the size of your data is like...

I think maybe the wording needs a bit of tweaking personally. Instead of "best way" (which is subjective) maybe what is the "MS standard way" or something less subjective, good...

Fraid so based on the def of vehicle

(from websters) def a

A device or structure for transporting persons or things; a conveyance

Don't worry got me also.

Thanks, it means what it means. Sleepless nights, lots of crying, dirty diapers and feeding all the time. But I can't complain I am just the father, mom has it...

Sorry Ken I have been out with a new baby and not doing much of anything. I have found did run across a reason why my solution will not fix...

The major issue I see is the higher potential for blocking processes. Some systems just have too many transactions to be feasible and those that don't so few there is...