All,

Thanks for your valuable inputs. I Asked DBA's to change compatability level to 90 but he did not agree as he is not sure if that would cause any other issues.

I created a new test database in SQL Server 2005 and was able to use ROOT command in that database. Other database (created

using SQL Server 2000) on same server gives error.