I agree with Franks choice as most look in realtime at what is being accessed so by excluding those that are accessed all the time it should be a non-issue...

Thanks, but topping things really isn't my goal. I can see your code does a quite lovely job. Just offering ("a better", just kidding ) another option...

Thanks phillcart, something new I had not used yet. I have a developer who has several places this will come in handy.

Classic case for using at least the two part name and why all objects should be owned by DBO.

Try the following tests to see what happens.

I run the code with all the variables and set them to static values to see if they return.

Also, try removing all the...

Ok, you could try SP 4 but sounds like you are trying to avoid. However, I have looked around and the problem is taht there are some similar things in...

That would be using

DTSTaskExecResult

which means you return retry failure or success. So you actually are returning a failure message thru the message pump. Just not thru the errors collections.

For you...

Ok I suggest taking a look at the memory on the server thru Task Manager while running and if using the wizard via your local machine do the same there...

If I understand correctly I think you are after this.

SELECT

BranchNode.NodeName as Site,

SUM(CASE WHEN DATVer < '4.0.4290' THEN 1 ELSE 0 END) as OutOfDate,

SUM(CASE WHEN DATVer >= '4.0.4290' THEN 1 ELSE...

Here is a script I wrote a long while back that does it and should cover all possiblities including the difference between hyphenation of things like Twenty-Five as opposed to...

Replication will be lost with backup restore if using.

Some old implicit datatype conversions no longer work so you may run into code that has varchar field and and int...

You might even try using C2 audit mode. This will produce a nice trace of those events without a lot to do ourself. However as with any tracing it is...