Do the triggers (or either of them) have the NOT FOR REPLICATION property?

John

I'd be surprised if that does what you intend it to. Assuming that the staging_eligibility_id column exists in both tables, it will return all rows from Staging_Eligibility table if...

I can't tell what you're trying to do, but do you get the right results if you remove the first MAX?

John

Not if there's no row to update, no. But say, for example, you were testing for rows that have a match on m_id but have different values for m_name....

John Mitchell-245523 (11/17/2016)

---

Manie

Yes, you do. Or every log since the last differential, if you have one. Maybe last time you were dealing with differential backups, not log backups?...

Manie

Yes, you do. Or every log since the last differential, if you have one. Maybe last time you were dealing with differential backups, not log backups? A...

But if the data doesn't exist at the destination server, there's nothing to update. You need to do an INSERT instead. In the absence of the requested table...

1. No, it's not a correlated subquery, so it only needs to run once.

2. Same as 1.

3. This is a correlated subquery. I'm not sure what your question is,...

You are using SQL Server, aren't you? What version?

Your update statement doesn't make sense, either. You're updating to set m_id in the outer table to be equal to...

Is that first query the actual query you ran? I'm surprised you don't get an ambiguous column error for the m_id in your select list.

John

Can you get any of the steps to fail if you run them manually? You may have to use EXECUTE AS so that it runs in the same context...

Mmmm... that's about as helpful as the government saying "Brexit means Brexit"!...

"Access is denied" sounds like an operating system error. Maybe you're trying to copy files to a location you (ie the SQL Server Agent or proxy account) don't have access...

I don't think you can do it with sp_who out of the box. What you can do is look at the definition for sp_who and create a new stored...

I think it would be quite a complicated solution in T-SQL, so much so that you may consider using a different language, but if you want to do it, here...