To initially get your database structures back into sync I would use Redgate Compare. After that, whatever process you use to change the structure of your main database must also...

Is there a reason you've abandoned this thread - http://www.sqlservercentral.com/Forums/Topic1740359-364-1.aspx, where people are trying to help you?

SELECT FORMAT(GETDATE(),'dd-MM-yyyy') is one way to do it - there are others.

I'd remove the formatting of the date from the ORDER BY - just ordering by the unformatted date would...

Please, in future post decent test data in a format that can easily be used by others - http://www.sqlservercentral.com/articles/Best+Practices/61537/.

Usually, when I see a question posted like this I just ignore...

Jacob Wilkins (11/23/2015)

---

Third, when you're adding your constraint, you do ON Scheme YearlyDateRange_ps, when that should not include the word "Scheme", and should reference the column that will be used...

You can delete or insert data by referencing a view, but the view itself only contains SELECT.

https://msdn.microsoft.com/en-GB/library/ms180800(v=sql.105).aspx

Show us your updated code, so we can tell what you have done to it.

It depends upon whether the data that you had locked was required by any overnight processes and what isolation levels were in use by those processes.

The data you hadn't...

My apologies - I mis-read the error message.

When you use IDENTITY_INSERT you also have to specify the column list for the table you are inserting into.

SET IDENTITY_INSERT [dbo].[Test_Table_1] ON

go

INSERT INTO...

Without seeing any code for the stored procedure, or DDL for the table I am assuming that the table has a column that has been created with the IDENTITY parameter....

Lynn Pettis (11/16/2015)

---

BrainDonor (11/16/2015)

I've lost count of the number of times I've prepared the material to explain a question, only to have found the answer in doing so.

SSC is my...

djj (11/16/2015)

---

I will be the first to admit I am not the smartest person, but at least I try to ask questions by providing requested information with my try at...

I would just like to say, that I've always admired the people that are willing to publish articles on this site.

Now that I've faced the editor for this, I really...

For anyone who didn't see Hugo's presentation at SQLPASS this year - "Every time you don't specify the schema, a little angel in Heaven dies".

GilaMonster (11/12/2015)

---

You can also do things like

myname+sitename@<domain> (or maybe the other way around). GMail...