"I've got a Transaction Log that just won't give in"

Question: Give in to size, multiple ldf files

Lifting the bar on '@activesOnly'

To latch on jpipes, maybe moving the where into the on clause. Do pickup some problems with it sometimes.

Check if query get any candidates for the update

Select Count(*) from tblshipping_sched

where NOT (shipped_qty is null)

Maybe more of the business rules aswell, how do you determine if Joe Doe is really Joe Doe in the other database, both maybe married to a Sue.

Have you tried

Select * from [_Actions_]

Have a look at

FIX: Invoking SQL-DMO Methods By Using "By Reference" Parameters May Cause a Memory Leak

at

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q293636

See SQL Server Books Online for

SET DATEFORMAT dmy

EXEC sp_configure 'two digit year cutoff'

The example can trace 'American family back to the Revolutionary War'. Quote from the article.

Done the lineage stuff in 6.5 but the lineage storage (varchar(255)) was a problem because...

Thanks for the example!

Will this help

If exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Parent_Child_Delete]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)

drop trigger [dbo].[Parent_Child_Delete]

GO

If exists (select * from dbo.sysobjects where id =...

Luckily, you are not using version 6!

Needs a bit more work

SELECT 1 as Tag,

NULL as Parent,

TopLevel.TopLevelID as [TopLevel!1!TopLevelID],

...

Agree with NPeeters

, sounds like an identity column will do the job.

Maybe completely irrelevant, but do you release all your object explicitly