Is this relevant to the thread you've posted in? If not, please start a new one.

It's not clear what your question is. If you're expecting the ALTER TABLE...

I think I'd set it up so there's a completely different task for the newer versions, and to test for server version in the control flow. That keeps the...

You're welcome. You do know you shouldn't use TOP without an ORDER BY, don't you? You're risking getting unpredictable results. If, as I suspect, your query only...

Use a temp table, table variable or staging table and insert into it thus:

INSERT INTO temp_table_or_table_variable_or_staging_table

EXEC ('<whatever>')

You can then select from the temp table, table variable or staging table as...

OK, please provide table DDL in the form of CREATE TABLE statements, sample data in the form of INSERT statements, and expected results. We should be able to help...

Do the missing rows from SALESINVOICE have NULL DELIVERYNOTE, by any chance?

John

Phil

I'd say you're missing a ")" at the end of both of those WHEN lines.

Edit - either that, or get rid of the first "(" on each line - I...

You answered the question yourself. If the column isn't found in the inner query, the...

Yes, check for triggers. If you don't find anything, try an extended events session to capture user creation, role membership changes and so on. That might give you...

Bear in mind that changing the database collation doesn't change the collation of existing columns (of user tables) in the database - it'll only affect new columns. So if...

In that case, Perry's script should return the same SID twice. Something strange is going on. You'll need to talk us through exactly what you're doing, please, perhaps...

I'll be there Thursday, Friday and Saturday. I'll look out for you all. You'll recognise me at the party if I'm the only one who's not dressed up!

John

Perhaps your login is mapped to a database user with a different name? Please run this:

USE MyDB

SELECT u.name

FROM sys.server_principals l

JOIN sys.database_principals u ON l.sid = u.sid

WHERE l.name = 'DOMAIN\serviceAcct'...

In that case, please will you post the exact script you ran to get that result, along with the script you ran when attempting to change the mapping. You...

Actually, I've just looked at your query again, and it can't be the one you ran. There's no such column as "user" in either of the catalog views that...