With the upcoming arrival of SQL Server 2008, the topic of CLR Integration (SQLCLR) is coming up alot again. Probably the biggest reason to use SQLCLR is to replace existing Extended Stored Procedures (XPs). According to SQL Server 2008 Books Online XPs continue to be a deprecated feature:
"This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use CLR Integration instead."
Alot of folks are pinging me about my last book, "Professional SQL Server 2005 CLR Programming" due to SQL 2008's arrival. If you would like to pick up a copy, the book's homepage is located here (click on the picture).
So, as far as I know at this time, no XPs are still not removed in SQL Server 2008, but trust me...THEIR DAYS ARE NUMBERED!