Thank you, Padhis. That is quite helpful.

agreed, a while loop in query window will do.

Thanks for the reply.

Yes, I did put a transaction rollback in the code. My question is: will rollback be recorded by the trigger above as well? I asked this because...

I queried with below but can find the only one above in the database. Anything I missed?

select * from sys.trigger

It is the query ran fine, but no data was updated.

Hi, Fritchey,

Sorry for the late response. The trigger is as below and there is no constrains in this table.

USE [APJNPIDB]

GO

/****** Object: Trigger [dbo].[updated_statuslog] Script Date: 09/06/2009...

You can set the package owner in the Visual studio and if the owner of the package and the account to run the package are same. It will be easy...

All,

Thanks a lot for your suggestions.

coby

Thanks but I want the result to be

cvr < 18

------------

adfd

I just want to make the column name to change by the value of the integer number, such as 18...

wangkhar, rudy,

Thanks for the advice. Do you know how to measure the time I need for the delete or roll back? Or, what is the max records we can endure...

Not sure this is the same issue I have ever met.

Did you checked the checkbox to install SQL Server SP4 recently? If you forgot to checked the checkbox, the installation...

Thanks a lot. This did work. -: ) coby

Sergiy, Michael,

I appreciate your answers.

Thanks,

coby

1. I was told that update itself is "delete + insert" actually but I think you are right because update is atomic itself and will not provide wrong data to...

Thanks a lot.

I will change "delete + insert" to "update + insert if not exists". The begin trans and commit trans are still needed, right?

Another question is:

Is it right that...