Thanks for taking the time to investigate beyond your initial instinct.  I'm looking forward to reading about it in your blog .

PS: Love the {sarcasm} switch

Thanks Phil, the simplest solution is often the best and I can't think of an edge case that I couldn't work around with that solution.

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

Dacpac works as a deployment mechanism (although there are shortcomings). However, it's now how you track a history of changes to objects in the database. There's just no easy...

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

At the moment I'm still a newbie to dacpacs, so I'm open to correction if I'm doing this wrong.

The objective is to execute the .dacpac on different environments that I...

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

Giles

Thanks for the prompt response.

It did cross my mind but as the production server isn't under my control I ruled it out quite early on.

I know this is an old thread but I've just encountered the same issue.

Someone had used a Maintenance Plan to backup the databases, Full at midnight and Differential every 4...

Thanks Phil Parkin, it's worked very well.

Jonathan AC Roberts, I agree with keeping the NOT EXISTS. If I can prevent the Insert then I should and IGNORE_DUP_KEY is only ON...

Jonathan AC Roberts, that's a very good point.

I'm currently Unit testing Phil Parkin's solution, which fits my brief and is elegant to boot.

Thanks for looking.

Giles

Sorry to reply to a 3 year old post but it is pertinent to a problem I've currently got.

I like Gail's article but the PK violation I'm getting is only...

Perfect, suits my needs perfectly thanks.

Just to expand for anyone reading this in future:

Whilst in my example the result of ROW_NUMBER can not be greater than the SequenceNumber if the...

I've been working from an article I've found, it works until I make the parameter Internal (the author does caveat that it might not work with Date Pickers) , I'm...

Hi, I'm not saying this is the issue but I've had similar issues when one of my rectangles just overlapped the item I'm trying to display, even by the tiniest...