Collate property set at DB level is not applicable to
-
Stored Procedures
-
Temporary tables
-
Views
-
Triggers
B
Correct answer
Explanation
In SQL Server, the COLLATE property at the database level affects permanent objects but has special behavior with temporary tables. Temporary tables are created in tempdb and inherit its collation, which can differ from the database collation. Stored procedures, views, and triggers can use collation settings within the database context.