sysprocesses

The sysprocesses table holds information about processes running on
MicrosoftR SQL ServerT. These processes can be client processes or
system processes. sysprocesses is stored only in the master database.

Example:

select loginame, count(*) from sysprocesses group by loginame


Untung D.

-----Original Message-----
From: Mulyono [mailto:[EMAIL PROTECTED] 
Sent: 31 Maret 2005 10:32
To: [email protected]
Subject: [indopb] Login ke SQL hanya satu kali


Dear IndoPber's,

Apakah ada rekan-rekan yang tahu bagaimana caranya
agar sebuah login id ke SQL Server/Sybase Server hanya
bisa digunakan satu kali?

Atau mungkin ada system table atau system store procedure yang bisa
memberikan informasi counter berapa banyak sebuah login id sedang
digunakan?

Thanks sebelumnya atas pencerahannya.

rgds

Mulyono
AIA Indonesia
IMPORTANT NOTICE: 

The information in this email (and any attachments) is confidential. 
If you are not the intended recipient, you must not use or disseminate
the
information.
If you have received this email in error, please immediately notify me
by
"Reply" command 
and permanently delete the original and any copies or printouts thereof.

Although this email and any attachments are believed to be free of any
virus
or 
other defect that might affect any computer system into which it is
received
and opened, 
it is the responsibility of the recipient to ensure that it is virus
free
and no responsibility 
is accepted by American International Group, Inc. or its subsidiaries or
affiliates either 
jointly or severally, for any loss or damage arising in any way from its
use.


[Non-text portions of this message have been removed]



-----------------------------------------------
 INDOPB TURUT BERDUKA CITA UNTUK ACEH & SUMUT 
-----------------------------------------------
IndoPB - Indonesia PB User Group 
To Post a message, send it to: [EMAIL PROTECTED]
To Unsubscribe,send a blank message to: [EMAIL PROTECTED] 
Yahoo! Groups Links



 





-----------------------------------------------
 INDOPB TURUT BERDUKA CITA UNTUK ACEH & SUMUT 
-----------------------------------------------
IndoPB - Indonesia PB User Group 
To Post a message, send it to: [EMAIL PROTECTED]
To Unsubscribe,send a blank message to: [EMAIL PROTECTED] 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/indopb/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 



Kirim email ke