SEO

permalink · #1 (**permalink**) 02-29-2008, 06:11 AM

Dear Group

I wondered whether there's a function or script that will show me
whether a user is currently logged-on to a MSSQL 2000 database? I'm
using SQL Authentication.

Thanks very much for your help & efforts!
Have a nice day!

Martin

permalink · #2 (**permalink**) 02-29-2008, 06:12 AM

You can use sp_who or sp_who2, or if you need something from code then
a statement like this will work:

if exists (select * from master.dbo.sysprocesses
where loginame = 'MyLogin'
and dbid = db_id('MyDB'))
begin
/* Do something here */
end

Simon

permalink · #3 (**permalink**) 02-29-2008, 06:13 AM

Hi Simon!

Thanks for the message. Works great!

M

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Is user logged-on?