on your client PC go to Start -> Run -> CMD

it should get you to the dos prompt

next type in the following line below and hit enter:

telnet yoursqlservername portnumber ...

hi

are you able to telnet to the SQL server from the client machine successfully on the port specified by you on the server?

let me know the result

hi

when u say you want to update the table after the products are sold...are you saying the SUM total should reduce?

if so like mentioned earlier in the thread...

As far as I know replication functionality is not incorporated by default in the SQL Server 2005 Express Edition installation.

however i did find the following article which might be of...