Display Users Script -- sql server new users

Sue Hoegemeier
3/3/2005 6:55:35 PM

In SQL Server you could just use something like:
select loginame
from sysprocesses
where spid > 50

For mySQL, it's probably a better idea to use a mySQL
newsgroup rather than a SQL Server newsgroup.

-Sue

On Thu, 3 Mar 2005 20:47:39 -0500, "StlyDan"
[quoted text, click to view]

StlyDan
3/3/2005 8:47:39 PM

I am looking for a simple way to display Usernames of those logged into a
simple site I have. Data is coming in from mySQL.

Do I need to add a TINYINT to my DB which will switch as they login in and
out, or is there a simpler way to show which users have logged on?

Thanks!

--
Respectfully,

Eric A. Pearson

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server new users

sql server new users : Display Users Script