Thanks Thom for the link and support.

This was all I needed , and I can perhaps understand that Microsoft want to push us to use the new tooling, but when...

• This reply was modified 2 years, 11 months ago by  Snakeyes.

As I mentioned in my post the links are there but unless you have an active subscription you cannot download it.

You can still download VS2022 , but as the original...

So here I am with a new laptop, forced to download the latest version that does not support one of the core functions I perform at my work.... I can...

I Resolved the problem by removing any manual Cipher and Protocol registry settings, and installing the SQL2008R2 Client Tools and then removing the Service account Profile and restarting the server.

I stopped the job mid way forcing it to roll back the bulk insert.

And started the Job again, and it successfully initialized and the error has been resolved.

Dont know if...

I just remembered that the subscriber did not expire, its database crashed / got corrupted and i setup subscription from scratch to resolve this issue due to the replication metadata...

You would need to add the new column to the publication articles and reinitialize the subscriptions

If it was Log Shipping then everything would go across. Even events like adding more...

Does anyone else have any ideas on how to Force a system SP to use maxdop 1 without changing the server maxdop or altering the proc with hint?

In case anyone is looking for the solution.

The below query would just monitor the waits for the sessions and just ensure that that does not spiral out of control.

SELECT *

FROM...

Thanks for response Grant.

I have double checked everything but i think it boils down to the fact that it is a system store proc and if you try select the...

Thanks a mill Gail

That does make perfect sense.

Regards

Thanks Gila

So if i keep trying to shrink the TempDB and it refuses to shrink a certain file past lets say from 4GB to 2GB and it stays at 4GB.

And if...

Thanks for the help Gila.

So if the server comes under memory pressure and the OS asks for memory will SQL give back some of the memory held in "AWE".