It's difficult to be future-proof. Today, you can restore an SQL 2008 backup on any later version of SQL Server, including SQL 2019. But there are of course no guarantee...

Personally, I think a database should be owned by an SQL login that exists solely to own that database, and which has not been granted any permissions at all.

But if...

So it seems that the entire database is owned by my-domain\ex-employee. Verify this with sp_helpdb and then change the DB owner.

Sorry, that was the name of the procedure. You put the name of the queue there.

Hm, if the queue has EXECUTE AS OWNER, I think you should not change the queue activation, but the owner of the queue should be changed. Which could be the...

In addition to the other posts: Perform the operation in a transaction at first do it with ROLLBACK, so that you can verify that you got the correct results and...

In SSMS, find the database in Object Explorer. Expand the Service Broker node. There select Queues. Find IdentityServerNotificationCleanup. Right-click and select Script as ALTER to New Query window. Change the...

The issue is that the service account for SQL Agent does not have permission on the share. You may be listed as the job owner, but that is irrelevant here.

If...

No disagreement with what Jeff says, but I only wanted to point out that there is no reason to use fn_varbintohexstr (unless you are still on SQL 2005), since you...

If you get back all as text, this is because the OLE DB or ODBC driver for 4D does it this way. Or all columns are simply defined as text...

I'm not sure what you are trying to do. (There is no STUFF command. STUFF is just a string function that removes or adds characters in a string.) But you...

Duplicate post, see https://www.sqlservercentral.com/forums/topic/cannot-open-backup-device-error.

The service account for SQL Server needs to have permission on the folder and file. If SQL Server is running under a local account like NT Service\MSSQLSERVER, the account for...

I guess that if you delete them, you will get problems if you try to use Policy Based Management. That is certainly a feature that is not very widely used....

It's always venturous to write a query only from a verbal description, as some details may be get lost. Thus, I recommend that you always include CREATE TABLE statements for...