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.
| Author |
Topic |
|
nick_nguyen2004
Starting Member
5 Posts |
 Posted - 2010-01-07 : 09:27:56
|
| Hi,in SQL 2005, I would to run a query or somehow i could find out hwat user is connecting to the database. Thanks a lot |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-07 : 09:31:07
|
| you can do that. use SYSTEM_USER or SUSER_SNAME |
 |
|
|
nick_nguyen2004
Starting Member
5 Posts |
Posted - 2010-01-07 : 10:14:33
|
| Please show me the script, how to to use this |
|
|
|
nick_nguyen2004
Starting Member
5 Posts |
Posted - 2010-01-07 : 10:16:47
|
| I figured it out, don't mind me, thanks a lot. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-07 : 10:17:07
|
welcome |
|
|
|
|
|
|
Query Who (user) connecting to the Database