The USE statement is for specifying database to use on the connected server, not for specifying a server.

You need to define & use a linked server (the definition would...

"AppVManagement"  & "AppVReporting" appear to be for Microsoft Application Virtualization: https://docs.microsoft.com/en-us/windows/application-management/app-v/appv-for-windows, https://docs.microsoft.com/en-us/windows/application-management/app-v/appv-deploy-appv-databases-with-sql-scripts

ReportServer & ReportServerTempDB are for SQL Server Reporting Services.

Note: This appears identical to a question that was asked on...

Do you know/can you determine if a big transaction occurred just prior to this problem?

Are you out of space? How much disk space is used and how much is available...

Do you have replication on that database?

Have you executed DBCC CHECKDB to check for errors? If it indicates errors, see this: https://www.sqlservercentral.com/articles/help-my-database-is-corrupt-now-what. Do not reflexively run repair w/o fully...

Those three have approximately 2/3 of the market, and are mostly (ServiceNow at #3) the fastest growing.  The top eight have 82% of the market. If you're in/find an industry...

SQL Server 2017 mainstream support ends in five months (extended support to October 2027). Why are you going to 2017 instead of 2019?

Create a new server.  Backup, restore, update statistics,...

How fresh does the data need to be? If a nightly update suffices and the servers are on the same network or otherwise able to copy files, then you could...

DDL Trigger

Not exactly clear what you're trying to do yet...

Are you talking about SQL Server's built-in change tracking, or some custom-built approach?

If built-in, and you want to identify the distinct change...

Backups store state at the point of backup.

Are you trying to implement a data retention policy that removes older data?  If so, you'd need to implement processes to do that...

This could probably be done with a DDL trigger.

So obviously the local admin has at least ALTER permissions, right? A user who can set it to single user could disable...

There is an AUTO_SHRINK property, but think hard about using it. Otherwise, the transaction log is only shrunk one tells SQL Server to shrink it by using DBCC...

Sticks = pipes ("|").  Thank you, Frederico! I guess I have heard that term, but not as commonly as pipe, and didn't make the connection here.

Ahmed: Questions --

• What do...

What do you mean by "sticks" in this question? There is nothing in you question or the DDL or data to explain that.

One of the best analogies I've seen on scanning vs. seeking -- for those old enough to even know what a phone book -- is:

A seek is like when you...