Hi Razvan,

I tried that, created a table first then insert records. SQLServer said it can not find newsubject_id field. That is very strange.

Thanks

I think I found a solution to ensure that before I start a transaction, there is no orphan transaction which can cause all sort of problem. Before you start the...

Mark,

The database is solely used by me. so locking tables I presume is ok because no one else is using it. Other people use different database but they all sit...