• The correct answer to this question all depends on what version of SQL Server you are using. SCHEMA_NAME() is only a recognized function in SQL Server 2005, not in SQL Server 2000 and since the version is not stated in the question there are 2 different answers to this misleading question..