Since the query is referring to the database in SQL Seerver 2000, when I creaetd the query to call sp_db_mail in SQL 2005 through link server , It came out with databse objet not found
After creating two way link servr it worked.
Provide me how to create a query out put from SQL Server 2000 in dbmail using the specified approach