Cep Nuris
Programming is the Art of Looping and Selecting Values (Nuris)
Friday, June 10, 2011
Mengetahui koneksi user di SQL Server
SELECT d.name, p.login_time,p.status,p.hostname,p.loginame
from master.dbo.sysprocesses p
join master.dbo.sysdatabases d on p.dbID = d.dbID
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment