Hope this will solve your problem

Try this

CREATE TABLE mytable

(

AccId numeric IDENTITY(1,1),

AccCustumId as (AccId),

test int

...

Go to control panel -> Computer Management -> Local users - > Users

check your user account is part of SQLDebugger account. If you add that you will be able...

Taken from BOL.

A table constraint is declared independently from a column definition and can apply to more than one column in a table.

Table constraints must be used when more...

I have faced a simmillar problem like this, but by reading the mails the solution to problem won't be with the varchar data type I feel.

Check any of your sql...

Is there any way to use the update in this context.

Like...existing rowid should be updated.

non-existing rowid should be inserted.

update b

Set b.column1=a.column1,b.column2=a.column2,b.column3=a.column3

from table2 as b

right join table1 as a...