You can try with OPENQUERY with help of Linked Server
CREATE TRIGGER LogRecords
ON mainlog
FOR INSERT
AS
BEGIN
SET NOCOUNT ON
IF EXISTS(
SELECT *
FROM mainLog
)
BEGIN
INSERT OPENQUERY(MySQLLinkedSvr,'SELECT * FROM Table')
SELECT * FROM INSERTED
END
END
For more information have a loon on this link:
http://msdn.microsoft.com/en-us/library/ms188427.aspx[
^]