Thank you, I really appreciate your comments!

for my account table, the primary key is accountId, which is an auto increment integer (I guess sql server will create index for primary...

thanks for your response!

do you mean if my transaction (select and update) last for 2 seconds,

and the web user create another account at the same time, he will proberbly blocked...

thank you all for so quick reponse.

one more question, if the table is not so simple, it's a big query

is there any way to avoid repeating the query in the...

thanks, and I've seen this before.

actually I don't want to load the inner package in ActiveX code like:

 Set oPkg = CreateObject("DTS.Package")

' Assign parameters

sServer = "(local)"

sUID = ""

sPWD = ""

iSecurity =...

thanks, luke

I got another problem when using the Execute SQL task:

I simply call a stored procedure in Execute SQL task, the stored procedure failed due to some insert error (but...

hi, greg

thanks for your input, I'm using the Execute SQL task now.

for the data driven query task, it's too complicate for me........