SQL Server 2016 is shipped with TLS 1.0 so it will be supported. However, TLS 1.0 itself is now End of Life so its recommended to upgrade it to...

Sorted 🙂

select
sysjobs.name [Job Name]
,CASE sysjobs.enabled
        when 1 THEN 'Job Enabled'
        when 0 then 'Job Not Enabled'
    End job_enabled
,CASE sysschedules.enabled
        WHEN 1 Then 'Schedule...

I feel a little bit like cupid on this thread but thanks for your responses 😉

much appreciated - that works!

appreciate all the feedback - I won't waste my time with it!

Thanks for the replies.
This is the first time I have used it, I normally use all the DMV's as mentioned above but was curious how DTA works and how...

out of interest.. why are you trying to open up the file?

Why not add it to a SQL instance and view the data that way?

This seems...

Hi

Is this constantly returning 1 or was this a one off? I would set up a job to capture this figure every 5 minutes or so to see...

We have a 3 node AG
Node 1 - Subnet 1 -Sync - autofailover
Node 2 - Subnet 1 -Sync - autofailover
Node 3 - Subnet 2 - ASync -...

Any ideas anyone?

I have just created an ADO.net connection to the listener which worked fine, then all of a sudden the OLE DB started working fine.

Tried with this multiple people and it...

Nothing very useful no, quite fustrating how it tells me its failed but cant find anything anywhere to tell me why..

1st error in cluster events:

Cluster resource 'AG1' of type 'SQL...