• 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