Communicating with a SQL Server installed on a remote machine using a web service

I have SQL Server 2005 express installed on my machine, and I was wondering if there is any way to have an asp.net 2.0 web service hosted by a different company be able to send sql commands to the sql server on my machine.

Yes.

It would require that you make your computer somewhat vulnerable to the internet.

You will have to open a port in the firewall.

You will have to deal with Web Services security issues or all kinds of folks 'could' be sending commands to your SQL Server. And if your security isn't 'irontight', one of those commands could even be "FORMAT C:".

So my point is yes, it can be done, I want you to understand that there are a lot of steps necessary to 'do it right'.

|||Thank you for your help with this. I think for now I will hold off on this until I can find time to research the security issues much more thouroughly.