Are you sure Ashok? I ran the query with SQL 2005 and got the conversion error.

One thing to check is that it's the version of the server software that matters not the version of the client software.

In other words, running SSMS 2005 when the server is SQL 2000 means that you won't get the error.