MS DTC Config Screenshot

If image not visible, pls Click Here

The main concern is that I have to send some data in destination server so that mobile operator can convey SMS.

Is there any alternative to do it beyond my activities?

Yes, it is a production server.

Actually I connect to database server through an application. The application is running in several computers. I enabled MSDTC in the all client computers.

To execute...

I don't know what is CU2.

I have enabled MSDTC on both servers going to Component Services.

In addition to,

I use Windows 7 Ultimate Edition & Microsoft SQL Server Standard Edition (64-bit) Version:10.50.1600.1

CREATE TRIGGER [dbo].[MyTrig]

ON [dbo].[Table1]

AFTER INSERT

AS

Declare @V1 varchar(50);

Declare @V2 varchar(50);

Declare @V3 varchar(50);

Declare @V4 varchar(50);

select @V1 = i.V1 from inserted i;

select @V2 = i.V2 from inserted i;

select @V3 = T2.V3...

Sorry for that. I am going to delete the post.

If I execute an insert query into linked server, it works. But when I use trigger to execute an insert query into linked server, it fails and generates the following...

@Bhuvnesh, I understood your point but right now I have to do in this way that I described. Management Decision.

@Bhuvnesh,

Actually it is a distributed query. I wrote an AFTER TRIGGER that will fetch information from six tables that will be SMS content and insert into a remote...

Thank you, Sir. Your code works.

Actually I wanna convey SMS from my database through mobile operator. That's why I want to insert data in my convenient format. If I use...

Thanks All. My problem has been solved. Now I take log backup regularly. It prevents tlog to be grown abnormally.

Special thanks to Gail Shaws' links.

Imagine that I take one full backup at the beginning of the day and later on take four log backups at two hours interval and again take another full backup...

Please suggest me what can I do to prevent tlog from growing. In addition to, I need your support to develop an effective backup plan. What activities...

@sjumani8462,

Actually I have tried in several environments. Under domain controller, beyond domain controller, local account etc. However, now I am successful to configure mirroring in different situations.

Thank you...