Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 can we get the system Name

Author  Topic 

boreddy
Posting Yak Master

172 Posts

Posted - 2009-01-28 : 02:46:23
My sql server 2005 in the server
many users connected to the that user (all users have same username and password)
if the one user is chnged the databse can we get that user systen name systeam name

thank you in advance

AvanthaSiriwardana
Yak Posting Veteran

78 Posts

Posted - 2009-01-28 : 04:57:32
use CURRENT_USER AND HOST_NAME

Avantha Siriwardana
Go to Top of Page
   

- Advertisement -