Are Common Table Expression's (CTE) available in SQL Server 2000

Question

I recently found the following article:

http://www.tsqltutorials.com/with-common-table-expressions.php

The article doesn't list which version of SQL server this became available in. Does this work in SQL Server 2000 and if not what is the earliest version that it is usable in?

Update: I did try a quick test and the test doesn't work. I'm asking that it doesn't work in SS2000 to ensure it isn't me or my setup.

Answer 1

Common table expressions were introduced in SQL Server 2005.

http://www.simple-talk.com/sql/sql-server-2005/sql-server-2005-common-table-expressions/