Any pointers anyone

Can you check Minimum & maximum memory settings on both the Instances. I had similar issues recently, memory setup was the issue.

More info.. from the DTC logs, I am seeing this

XACT_E_DUPLICATE_GUID

I got it resolved. This was the issue.

Minimum Server Memory was set to 0. Max memory was set to default value (large value) 214.......

OS was not getting enough memory, hence...

• This reply was modified 5 years, 1 month ago by  GonnaCatchIT.

It should be, since its just a XML file. You use .net c# script task to modify DTSConfig files, search for it - you will be able to find lot...

U can try exploring the CLR assemblies feature of SQL. However not  recommended to keep modifying the DTSConfig files programatically. OR another (kind of dirty) way

Write a SSIS package use...

• This reply was modified 5 years, 2 months ago by  GonnaCatchIT.

If ONLY procedures are in scope, you can use this

--Find a string in SPC

select * from sys.procedures where object_definition(object_id) like '%string%'

Run it in each of the DB's manually or automate...

If you want it in one single query, something like this..

Works for your sample cases, test for few more

select

fn.widget_id,

max(final.person_id) as person_id

from

#test fn

left join

(

select main.*

from

(

select min(t.rn) as rn,t.id as id,t.amount as...

I did the setup for All execution report.. I am getting 'UnExpected Termination' & there is no OnError events fired...

I think it's just a misleading error from SQL dump, can it be ?.

More info - Package works fine when running from Visual studio. Only on the server when  we...

OLEDB Provider for SQL -- does this work with provider 'MSOLEDBSQL.1' ?

Dear All,

For everyone. We resolved this issue by installing oraMTS service. To check if it's installed. Go to services.msc and check oraMTS Recovery service is running.

After Installation, make sure to...

Thanks a lot, we found this was missing in our  SQL-2014 box. We are trying to Install the OraMTS component.

Dear All,

Thanks for all the Inputs.  When I turned ON 'Legacy Cardinality Estimation', the same query got executed in 6-7 seconds.

With OFF, it takes over 2 minutes.

So I will review...

• This reply was modified 5 years, 3 months ago by  GonnaCatchIT.

Yes, this is the only code.. Could this be SQL Management studio issue as well ?.

FYI.. & DB is SQL Server 2016 Developer Edition

Microsoft SQL Server Management Studio 14.0.17119.0

Microsoft Analysis...