You can definitely quite easily publish the contents of a table in SQL Server to the web - e.g. using WCF Data Services.
But you cannot have the webservice "push" the changes to its clients, e.g. the webservice cannot detect changes and then notify the clients. The clients have to come and ask the web service for the data ("pull" model).
If you need to be able to notify clients of changes, you might be better off posting a message onto a message queue (like MSMQ) and have the clients who are interested in that data notification listen on that queue for new messages to show up.