Alternatively:

SELECT TOP 1 login_time FROM master..sysprocesses (NOLOCK)

ORDER BY login_time

Since I've noticed that on some of our SQL servers spid 1 is not the longest running process!

How, I don't know! Maybe someone more knowledgeable can explain