Deprecation

If you are building any serious SQL Server solution then it is strongly recommended that you use SQL Profiler and monitor the "Deprecation Event Category", which has two classes. One of these classes tells you that the feature used will be removed in the next major version of SQL Server and the other that it will not be removed in the next major version but a major version after that. Take a look at http://msdn.microsoft.com/en-us/library/ms184287.aspx for further details.