Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Returns the domain name and user name of the current connection.
The returned value is a string with the following format:
The following example returns the user name of the user that is executing the query.
WITH MEMBER Measures.x AS UserName SELECT Measures.x ON COLUMNS FROM [Adventure Works]