Moving Database Files

    -- Step1: put the database offline
    ALTER DATABASE [Database_Name] SET OFFLINE;
    GO
    
    -- Step2: move the file to the new location
    ALTER DATABASE [Dataabase_Name] MODIFY FILE (NAME = [Logical_File_Name], FILENAME = 'New File Path')
    GO
  
    -- Physically move the file to new location

    -- Step3: bring the database online
    ALTER DATABASE [Database_Name] SET ONLINE
    GO

Check your Databases are set to Trustworthy

SELECT dtb.[name] AS [database],
CASE(dtb.is_trustworthy_on)
WHEN 0 THEN 'False'
WHEN 1 THEN 'True'
END AS [Trustworthy]
FROM master.sys.databases AS dtb;

To change database to Trustworthy:

ALTER DATABASE DatabaseName SET TRUSTWORTHY ON
GO

Finding SQL Collation with SQL Transact

SELECT DATABASEPROPERTYEX('<DB_NAME>', 'Collation') SQLCollation