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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-09-30 : 08:06:11
|
| Babis writes "I' m trying to find a way of sending a custom message from my application (an Access Project connected to SQL2000 - 08.00.0760) to all users who are in the same database. How can i get them in a recordset or any other way/format?" |
|
|
dsdeming
479 Posts |
Posted - 2003-09-30 : 08:19:35
|
| Have a look at the sysprocess table. SELECT * FROM master..sysprocesses WHERE dbid = @MyDatabaseID. The dbid corresponds to the PK in the master..sysdatabases table. You'll find the NT username and login name in there.Also, search this site for net send. That may be the easiest way to notify the affected users.Dennis |
 |
|
|
|
|
|
currently Logged users in Database