Using sp_who to generate a "write" 
Author Message
 Using sp_who to generate a "write"

Hi! I'm grabbing the login names and host names from the output of
sp_who and trying to send a message to that user at that host.

"write: 0803-031 Permission denied."

pts # is valid, it works just fine.

Without special permissions, how do I get either the ## value for
the pts that the server is connected to (all all of them would be OK)
OR how do a get the "write" by itself to work?

I'm doing this using sybperl. The purpose is to send a message to
everyone logged on to the server before I take some specific action.


Tue, 16 Jun 1998 03:00:00 GMT
 [ 1 post ] 

 Relevant Pages 

1. sp_who and "CONDITIONAL" connection

2. "UNKNOWN TOKEN" in sp_who display

3. sp_ps (A little more than "sp_who")

4. max of ("...","...","..")

5. Error: "Cannot generate SSPI context"

6. Schedule The "Generate SQL Database Script"

7. "Cannot generate SSPI context" Error

8. "Cannot generate SSPI context" Error

9. "No output generated during replication"

10. Generate a "create" script (reverse engineer)

11. query analyzer "no script generated"

12. Generating scripts for "DBCC SQLPERF (LOGSPACE)"?

Powered by phpBB® Forum Software