Hi,

It might be worth looking at Partition Switching as a possible option as well:

https://www.jamesserra.com/archive/2012/07/sql-server-table-partition-switching/

Have a look at the READPAST hint (https://docs.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-table):

You can kill an orphaned transaction (lookup the KILL command in BOL) which will prevent you having to restart the service.

Leyton

Hi,

Did you read the BOL article on merge that I posted earlier? There are some good examples there.

The pertinent bit though is:

Performs insert, update, or delete operations on a target...

Hi,

You can't do what you're trying.

According to BOL (http://technet.microsoft.com/en-us/library/bb510625.aspx) WHEN NOT MATCHED only allows INSERT.

And it you can't update a different table to the target.

BTW 3 part naming...

Hi Edwin,

You need to change the column definition to be NVARCHAR to support unicode. Here's a script to show you how:

USE Test

GO

/* Create Test table with non-unicode column */

IF OBJECT_ID('dbo.Test',...