Collate property set at DB level is not applicable to
Stored Procedures
Temporary tables
Views
Triggers