Here's what we do. My tables have an is_delete bit on them. When a record's is_delete bit is set on or off, a trigger cascades the is_delete bit...

Right answer. 10 points.

declare @exp1 varchar(32) = 'username'

select SUBSTRING(@exp1,1,(LEN(@exp1) - 1))

--returns 'usernam'

declare @exp1 varchar(32) = ' '

select LEN(@exp1)

--returns 0

select SUBSTRING(@exp1,1,(LEN(@exp1) - 1))

--Msg 537, Level 16, State 2, Line 4

--Invalid length parameter passed...

EXCELLENT:

Working with tempdb in SQL Server 2005

http://technet.microsoft.com/en-us/library/cc966545.aspx#

SELECT ColA = 'A'

into dbo.tbl_pk

UNION

SELECT ColA = 'B'

SELECT ColA = 'A', ColB = '1'

into dbo.tbl_fk

UNION

SELECT ColA = 'A', ColB = '2'

UNION

SELECT ColA = 'A', ColB = '3'

UNION

SELECT ColA = 'A',...

Thx - I'll kill some trees.

exactly right. and just what i needed.

Works! SWEET!

Oh heck yeah I like that...

Sweet Thanks!!!!!

It was actually 421 lines of code. I went with a sproc and did as you said.

Thanks!

I figured it out! Right click on image and select "send to back".

Oh and same thing goes for tasks in those daughters. You can force package failure in the tasks within the daughters and send mail from there I think?

Did you go into the properties of the task and change FailParentOnFailure to TRUE? The default is FALSE.

HTH