Thank you for your help. I think I still need to use back the current method to generate the Id, coz It is a common function used by the system...

Not sure the code below can help you or not.

If Request.ServerVariables("HTTP_X_FORWARDED_FOR") = "" Then

    UserIP = Request.ServerVariables("REMOTE_ADDR")

Else 

    UserIP = Request.ServerVariables("HTTP_X_FORWARDED_FOR")

End If

'Then Check whether the UserIP is under your IP...

Thank you for the help.

This Topic is resolved. Please refer to http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=231494

Thank you.

Thank you for all of you help. I think I know what to do already.

Dear rsharma,

I just did a test to use the isql and osql to run the scripts and it work! Do you know why the isql and osql not so popular? Is it...

Dear David,

Thank you for your reply. If I not mistake, the varchar length in the sql server 2000 maximum is 8000. And the scripts I  have may exceed this limit....

Yesterday morning i do a testing on the same SP. I create a testing asp page to call the SP 500 times. I open the three same asp page simultaneously, finally...

Thank for your reply. I agree that good practise in ASP can improve the speed of the website. But some time, if the processing logic is very complex which require...

I found from some acticle said that we should include the begin, commit, rollback transaction in the SP. What is the good way to include it?

I create a SP...