When a user submits a registration form, all data from the form will be saved in my database which is MSSQL server 2000. At the same time, I want to send the data to the other website located on the different server. Does anyone have any idea about it? Thanks in advance.

Perhaps on the other Web site have a page that can take a querystring and enter that data into the database. And on the first Web site have a popup window link to the second Web site with directions for the user to click the link to enter the data into the other site (and then the user can close the window).

It's clunky but at least it's something.

What do you mean when you say "I want to send the data to the other website located on the different server" ? Do you mean to another sql server instance ?

That's the co-registration project. When a user submits a registration form on website A, the user's info needs to be sent to another website B and to be stored into B's database which is located on another database server.

You can write your ASP script to update 2 SQL Server databases

or

You can replicate table data from 1 SQL Server instance 2 the other.

or

You can do a link server from SQL Server 1 to 2 and do a join view.