Yes, I have running transaction log backups in both servers.

Thank you for your guidance. I will go through the link. Again thank you very much for being with me.

Welcome for your interest.

1. Yes, I can remote desktop onto the server and the server has SSMS installed and I can work on the remote desktop session.

2. Yes, I am...

No, Sir. I have meant that there are 13 different servers and 13 different instances. That means every server has only one single instance that is default "MSSQLSERVER". I can...

TCP/IP, named pipes, VIA enabled.

No solution at all. That article did not help me. Because I am not finding any RESOURCE_SEMAPHORE waittype. Please any more help.

Here is my full trigger. Please help me.

CREATE TRIGGER [dbo].[myTrigger]

ON [dbo].[myTable]

AFTER INSERT

AS

BEGIN

DECLARE @IP VARCHAR(15);

select @IP = client_net_address

from sys.dm_exec_connections

where session_id=@@SPID

IF (@IP = '127.0.0.1' )

BEGIN

RAISERROR('You can not issue',16,1);

ROLLBACK

END

END

GilaMonster (12/23/2014)

Change the behavior of the query processor

Restore to a 2012 server, or script and...

Thanks for your quick response. I have two more queries.

a) Then what does "Compatability Level" do here?

b) And what to do in this scenario?

Thanks.

I tried all the way out but in vain. I am not getting any clue.

@spaghettidba,

I have used rollback and also require to display an error message. But the message is not appearing. I have used the following code.

begin

RAISERROR ('Sorry!You have entered...

Actually I run select * from table where condition but I don't get any rows. Then I restart my production server and execute the same query and find some rows....

@gilamonster, Thank you for your valuable time and suggestion.

Yes, I found information that someone has opened Edit window but did not find what has changed....

I capture the following event and filter in the trace file.

EXEC sp_trace_setevent @TraceID, 12,1, @on --SQL-BatchCompleted,TextData

EXEC sp_trace_setevent @TraceID, 12,6, @on --SQL-BatchCompleted,NTUserName

EXEC sp_trace_setevent @TraceID, 12,8, @on ...