SQL will not release space automatically to match what the internal size is.

If you want to release the space back to the OS you need to manually and consciencely issues...

check the windows error logs also application/system/security it should guide you better to whome is doing it

Take a look at the delimitedsplit functions, do these do what you need.

https://www.sqlservercentral.com/forums/topic/using-the-delimitedsplit8k-function-help-jeff

Check the setup bootstrap logs, by default they are in "C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log" with a time stamped folder for each run of the scenarioengine process.

The summary and detail...

Will probably have to repair the instance.

Might be worth getting a consultant in to do a deep dive into the server, it's not something which can easily be done on...

Unsure then, if your doing whatever functionality it is as a sysadmin account and the function is there, something is for sure a miss.

If you're not using policy based management,...

If you where to navigate in object explorer as someone with sysadmin rights, do you see that function??

Post the exact error message(s) as they are shown on screen.

The general fix for that error is that your agent XP's are not enabled.

Also a copy of the output of

dupe post

Enable the agent xp's via sp_configure

More than likely you have a DML DDL trigger enabled somewhere, that needs to be modified or disabled while you run any CDC enable/disable operation, as CDC tasks execute as...

More than likely you have a DML DDL trigger enabled somewhere, that needs to be modified or disabled while you run any CDC enable/disable operation, as CDC tasks execute as...

SOX audit gunna eat them alive.

That trigger was placed there for a reason.

In financing terms once something is on a journal / ledger, it should ALWAYS remain on that journal / ledger.

If there was an...

Unable to open the physical file "D:\dbs\sh\5uj5\1008_054209\cmd\11\obj\x64retail\sql\mkmastr\databases\mkmastr.nativeproj\model.mdf"

SQL thinks it was installed to the D: location.

If you don't have a D: then you'll need to uninstall SQL and install it to...