Still think it’s part of the insert in the proc as the convert to char needs to be outside of the dynamic SQL, as for why it was giving a...

My guess would be some implicit conversion happening here

INSERT INTO DBO.OptionsEOD
SELECT *, ''' + @RECORD_ADD_DT + 
 ''' AS TIME_STAMP
FROM #TEMP_TABLE'

Cant see nothing else which could be...

Yeah that all looks good.

The .NET ones need a full OS restart to take effect though I am afraid.

Could you confirm which registry keys you have enabled?

Did you also enable the ones for .Net to be able to use strong cryptography? (Note .Net registry keys are only needed...

And what solution do you use for index maintenance?

For me I would be using Ola’s solution and ensuring the LogToTable parameter is set to Y so I could track the...

Index maintenance can only work on databases which are online.

What technology are you using to keep primary and secondary syncing?  AOAG, Mirroring, Log Shipping, Replication?

If AOAG, mirroring, log shipping the...

Add a count check around this line

select * from #identity_columns order by percent_consumed desc

If there is nothing in the temp table, then skip over the select

            
April 19, 2023 at 8:14 am
            
#4176149

            
            
                                                
        

It's probably some internal check that says you cannot use a licensed software (Your SSRS Standard server) against a free/dev edition to prevent some licensing issues.

Can you install SSRS as...

Microsoft certifications are not going away, they are just shifting the focus onto other places.

This is the equivalent to the old MCSA/MCSE for the DBA route

https://learn.microsoft.com/en-us/certifications/exams/dp-300

This is the new data...

Does the antivirus software you use have a CLI?

You could write a script task in C#, VB.Net to interact with your AV and call it to scan the file in...

While the DB is part of the AOAG you cannot change to simple mode.

But as you will be removing the database from the AOAG, you can then set it to...

So your waiting for log backup which means you have probably never even done one in that database's life time given the size of the data and the size of...

The joining clause in step 2 needs to be more selective.

rec.ChainID = T.ChainID will there be a CROSS JOIN as each row in step 1 relates to each and every...

So have you run out of space on the log drives?  The first thing would be to add more storage to each log drive and let the databases continue sync'ing.

Otherwise,...

Only thing I can see is that it is waiting for log memory, the temp/table var don't require log memory.

But it is constant physical table under performs on the standard...