select serverproperty('collation') as server_coll, 
       databasepropertyex('test', 'collation') as test_db_coll,
       databasepropertyex('test_Latin1_General_CI_AS_KS_WS', 
       'collation') as test_Latin1_General_CI_AS_KS_WS_db_coll;
go
	
DECLARE @banc TABLE (mask1 NVARCHAR(100), mask2 NVARCHAR(100),
        name NVARCHAR(100));
INSERT @banc (mask1,mask2, name) VALUES   
(N'%рога%', N'%копыта%', N'Рога и копыта') ;
    
select *
from @banc b join test.dbo.client_cyr c on c.FirstName like b.mask1

use master
go

alter database model collate Cyrillic_General_CI_AS
go
----------------------
Msg 3708, Level 16, State 5, Line 2
Cannot alter the database 'model' because it is a system database.

select db_name(), databasepropertyex(DB_NAME(), 'collation')

select name, collation_name 
from sys.databases
where collation_name = 'Latin1_General_CI_AS_KS_WS'

DECLARE @banc TABLE (mask1 NVARCHAR(100) collate Cyrillic_General_CI_AS, 
                     mask2 NVARCHAR(100) collate Cyrillic_General_CI_AS,
                     name  NVARCHAR(100) collate Cyrillic_General_CI_AS);

create table dbo.t (col1 NVARCHAR(100) collate Latin1_General_CI_AS_KS_WS,
                    col2 NVARCHAR(100) collate Latin1_General_CI_AS_KS_WS);
go
                    
alter table dbo.t alter column  col1 NVARCHAR(100) collate Cyrillic_General_CI_AS;
alter table dbo.t alter column  col2 NVARCHAR(100) collate Cyrillic_General_CI_AS;