minutes, hours, days, weeks, depends how much data on the right of the file it has to move to the left and how fast your storage IO subsystem can move...

Well everything needs space, all the data you have been loading, deleting, changing, indexes added / deleted it will have all taken space.  When you drop that index which took...

What type of client is in use?  Is it some fat client or is it some sort of web based SaaS app you have.

Done something with SSRS in the past...

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...