I have a column that has an `ident_current` constraint on it to populate another column, like so:

```
alter table dbo.Employee 
add constraint dbo_Employee_D1 default ident_current('dbo.Employee') for SourceID`

```

When using `ident_current`, I have a risk of not always getting the correct identity value in case multiple threads execute my SQL. I wanted to use `scope_identity()` instead. But how do I use it? I cannot simply replace `ident_current` with `scope_identity()`.

```
alter table dbo.Employee 
add constraint dbo_Employee_D1 default scope_identity() for SourceID`

```

An option is to use an `AFTER INSERT` trigger. But won't this have the same issue in multi-threaded environment?