What does "%%DatabaseEx" do in TSQL?

Question

I was looking at the source of sys.sp_dbcmptlevel in SQL Server 2005.

In the source, there is this line I do not understand how it works.

EXEC %%DatabaseEx(Name = @dbname).SetCompatibility(Level = @input_cmptlevel)

It doesn't appear that DatabaseEx is a stored procedure.

-- does not return any result
select  *
from    sys.procedures
where   [name] like '%DatabaseEx%'

So my questions are

• What is DatabaseEx and what does it do?
• What is %% before DatabaseEx?

Answer 1

I think the best answer here is that it's not documented, and not supported, so don't rely on it. While it's interesting to know how SQL Server works internally, anything you do with that knowledge has the potential to break in a future hotfix, service pack or release.

Answer 2

Interesting find.

System SP's also refer to %%Object, %%Relation, %%ColumnEx, %%LinkedServer, %%Owner, %%CurrentDatabase(), %%ErrorMessage, %%Module, %%DatabaseRef, %%LocalLogin, %%Alias, %%ServerConfiguration, %%IndexOrStats, %%ScalarType (etc)

My interpretation is that the %%() retrieves some kind of (COM?) object based on filter criteria, followed by a method call.