In the left pane, click the Users & Groups folder.

In the right pane, the publisher is the user whose Type is Publisher.

Use the CURRENT PUBLISHER constant. The following statement retrieves the publisher user name:

SELECT CURRENT PUBLISHER;