Processing XML Showplans Using SQLCLR in SQL Server 2005
Another article on MSDN on SQL Server 2005. Interesting read ... Build an application to extract a query's estimated execution cost from its XML showplan. Users can submit only those queries costing less than a predetermined threshold to a server running SQL Server 2005, thereby ensuring it is not overloaded with costly, long-running queries.
Pointer to article.