http://sqlblog.com/blogs/greg_low/archive/2009/02/05/function-calling-sequence-deprecated.aspxAnother item that I've seen used a lot which is now deprecated is the :: function calling sequence. If you have code like: SELECT * FROM :: fn_virtualfilestats ( 2 , 1 ); You should now instead be coding it as: SELECT * FROM sys . fn_virtualfilestatsenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/greg_low/archive/2009/02/05/function-calling-sequence-deprecated.aspx#11729Thu, 05 Feb 2009 09:16:58 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:11729colin leversuch-roberts<p>well it sort of makes more sense .. I guess I'd already encountered this but as I can never remember how to call functions in a select I tend to go through the various options until it works!</p>http://sqlblog.com/blogs/greg_low/archive/2009/02/05/function-calling-sequence-deprecated.aspx#11732Thu, 05 Feb 2009 13:20:56 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:11732James Luetkehoelter<p>This makes sense to me if it is a truly a table-value function (like sys.dm_db_index_physical_stats), but if it is a scalar function that replaces a server &quot;function&quot; like @@servername, I see no sense in this. To me this muddles the concept of the original @@servername scalar system functions with the system functions like the dm views (which are sometimes table-valued functions).</p>