Thanks,

As pointed out, the queries have different attributes.

It is also explained here : https://www.sqlservergeeks.com/sys-dm_exec_plan_attributes/

That is a huge difference. I suspect you run both queries in SMSS ? The execution plan is the exact same (including estimated/actual statistics) ? SET STATISTICS IO ON return the...

Hi,

Yes I use the same set options. I use sp_executesql in SMSS in order to get the same query as the one generate by the application. 

DECLARE @P1 int;
DECLARE...

Hi,

When it comes to "disaster-event" you need to think about those 3 topics: Backup, High-Availability, Disaster Recovery.

Now it seems you want to tackle the Backup topic....

It means Service Pack.

If people have local admin rights on their machine, their is nothing that will prevent them to create a local SQL Server not accessible from the network. You would need...

I had a similar issue in the past and found warnings/error in the event logs. From there, I googled and found a known issue and a registry key.

Did...

I do not know the nature of your development, but I would leave the service set to "Manual" and start/stop on-demand if you do not need SQL Server on daily...

Hi,

The answer to your question will reside in the event logs of the machine or SQL. When you start it, does it remain started for a while ?

Would it be correct to say that RPC:Completed and SP:StmtCompleted are tied to a specific query, but the whole transaction can roll back later ?  Is there any way in SQL...

Hi

From SQL Profiler, I can see there is a Rollback Transaction Starting and Rollback Transaction Started. I suspect that is the cause of this issue. 

It is...

Hi

Thank you for all the input.

I know it seems that I am not looking at the right thing or I have the wrong parameters, but...

Hi,

Are you thinking that another query would revert the change ? I can confirm there is not based on the SQL Profiler Trace.

Also, there is no...