Why not run a quick test and find out for yourself?

Do a DB schema compare against what you have stored in source control to identify any 'drift'.

Not answering your question, but a quick note about your existing SQL, as it can be made considerably more concise, using the following structure:

SELECT *
FROM src
 ...

Hi, I have included FIRE_TRIGGERS in fast load mode and my package is failing with error "An error was raised during trigger execution. The batch has been aborted and...

Hi Phil,

Yeah its identical, I am simply executing the execute SQL task by right clicking on it in VS.

That works whereas running the package in its entirety causes the...

Are you 100% certain that exactly the same SQL is being executed in each case?

'Null' is a string. Do you really have strings containing the word 'Null'?

NULL is the absence of data.

As you don't want to remove all rows, your TRUNCATE comment is not...

But surely regardless of where and how I store it, the issue I've got is how to extract it (the version)

I'm sure I'll figure something out once I've been...

It's certainly an option, although whilst I try to make all my scripts "idiot proof" I can't vouch for how meticulous the DBAs are that I'll be handing the...

You're not doing anything wrong. Deployment processes often vary from one organisation to another.

Perhaps the simplest solution would be to hand the DACPAC to the DBAs along with a .sql...

msdb.dbo.sysdac_history_internal doesn't contain anything regarding the dacpac version, so in this situation I would say that it doesn't contain anything useful, but thanks for continuing to look at my...

Phil Parkin wrote:

Generalising your argument:

It's OK to discriminate, as long as the one discriminating is in the minority.

Are you comfortable with this?

Congratulations Phil. After years of silent lurking, you managed...

Fair enough.

Does the table msdb.dbo.sysdac_history_internal contain anything useful?

Completely missing the point, Phil.

It's not discrimination. You are not being forbidden from attending these conferences. You are not incapable of getting jobs or networking because of your gender...

The problem is that women and PoCs don't have an equal seat at the table. Men is Tech and White is Tech is the systematic default. Everything supports CIS...