Nicole

If you query sys.servers, you should find the information you need in the provider or provider_string column.

John

Curious. What does this return?SELECT COUNT(*)

FROM sys.database_files

WHERE type_desc = 'LOG'

John

You probably haven't refreshed the GUI. I used to make that mistake all the time!

John

That's right, yes - also if the column has the wrong value you can update it to the correct one.

You might also consider using the MERGE statement, which inserts and...

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...