I get asked this question all the time. What is possible in different types deployments of MS CRM 4.0? I found this link quiet useful.  The article provides a concise description regarding availability of Microsoft Dynamics CRM extensibility features across the three types of deployments. Very useful if your considering a solution for a client.

Extensibility Feature Deployment Comparison for Microsoft Dynamics CRM 4.0