Thursday, May 31, 2007

SQL Server version of 'whoami'

This is related to my previous post about connecting to SQL Server using integrated security. I needed to find out what identity I was connected as when accessing SQL Server. A quick Google search yielded this SQL statement:

SELECT suser_sname();

No comments: