I am just showing my observation. I saw it in server level connection settings. I didn't find any setting database level setting.

Any idea, on how to set this option from...

If XACT_ABORT is ON, an error will cause the whole transaction to be rolled back; if it's OFF, only the statement being executed will be rolled back.  When XACT_ABORT...

Thank you MVDBA.

Hi All,

Thank you very much for expressing honest thoughts.Many thanks. It means a lot for people like me.

-Sam

Okay. Thanks for taking time. The problem is we can tell them to re-write query but this query was stable since a long time. And changes has to be to...

@Taps - Thank you. What you said might be the case.

One more thing , Is there a way to control the number of rows in ssms while loading big batches...

Hi Jonathan, Thanks for the reply.

This query used to run fine within a min. don't know why it is taking long time and never finished.no blocking, waitype shows null,  status=running......

• This reply was modified 5 years, 10 months ago by vsamantha35.

Hi @Taps,

I can now understand that UNION operator gets rid of duplicate records and makes the insert go through fine( Case 2).

Any thoughts on why CASE1 is failing? The union...

Thanks everyone for explaining your views.

Hi Thom, How to approach such people issues. This is been like a habbit for the dev team to send out email to dba team to tune as...

The problem is the code that is "overly" using TempDB; you can't make TempDB use less space. Those that wrote the query need to fix it; if it's using...

Restarted the MSDTC service as it is a Development server. It fixed the orphan spid. Now the restore is in progress.

Thank you All for the suggestions. Yes, we run the backups as part of SQL Agent Job.

Error message from application log from app team

=====================================================

Error connecting to database [

[Informatica][ODBC 20101 driver]7505

Database driver error...

Function Name : Connect

Database driver error...

Function Name : Connect

Database Error: Failed to connect...

In our case, when I try to connect using kevin user from windows machine, where SSMS is installed , I don't see any issues. Which means there is...