Change "<source_db>.dbo.tbl_Users" to "inserted" in the from clause and that should get what you want.

Sure you can, if you do it correctly:

select count(AddressID)

from Address

having count(AddressID) > 1

Issue a ROLLBACK in the trigger after the CATCH and before the INSERT.

As a quick and dirty, I would do this:

with counts as (

select * from

(select count (*) as Col1 from sys.columns where (column_id = 1)) x

cross apply

(Select Count (*) as...

Mark-545947 (2/14/2013)

---

toddasd (2/14/2013)

---

So the trigger itself runs correctly from both sources. And there are no triggers on the tables BACK or BACK_RLFL. The only part left is the guts of...

So the trigger itself runs correctly from both sources. And there are no triggers on the tables...

Take the BACK tables out of the equation....

Mark-545947 (2/14/2013)

---

I understand your point of trigger firing on batches and not on rows. Then why doesn't my trigger work when I insert into it ONE record (FROM SSIS).

Here is...

This makes more sense:

CREATE TRIGGER [dbo].[ArchiveBACK] ON [dbo].[RLFL]

AFTER INSERT

AS

SET NOCOUNT ON;

INSERT INTO BACK_RLFL

SELECT b.*

FROM BACK b

WHERE b.OrderID in (select i.OrderID from inserted i)

GO

Mark-545947 (2/14/2013)

---

Sure it does for the situation of archiving what is not already there, but now you've introduced a new table, BACK_ARCHIVE. So I see four tables: BACK, RLFL, RLFL_BACK,...

Sure it does for the situation of archiving what is not already there, but now you've introduced a new table, BACK_ARCHIVE. So I see four tables:...

I was playing around with this, and came up with this as a pretty simple approach:

ALTER TRIGGER [dbo].[ArchiveBACK] ON [dbo].[RLFL]

AFTER INSERT

AS

SET NOCOUNT ON;

INSERT INTO BACK_RLFL

SELECT * FROM INSERTED ...

Use cross apply, like so

select * from

(select count (*) as Col1 from sys.columns where (column_id = 1)) x

cross apply

(Select Count (*) as Col2 from sys.columns where (column_id = 2))...

Sure, I'll help out.

First, there is no need to capitalize random words in sentences. I can't tell if it is for emphasis or not, but either way, it's not...

Just initialize the string with that query, like so:

Declare @loopYrbeg int

Declare @loopYrend int

Declare @tablename sysname

Declare @sql varchar(MAX)

Set @loopYrbeg = 2007

Set @sql = 'select * from tableCurrent...