Broadcast 30/15/5 min before shutdown FROM sp.

  • Thread starter Thread starter Mario
  • Start date Start date
M

Mario

From a stored procedure what is the way to broadcast, I do
not want do send the net /users command since this is
server related. I want only to disturb my SQLServer users
at the time, I can go to sysprocesses and find the user
names but what is the hidden sp or xp that will let me do
that?

TIA
 
mario;

i would have some sort of global messaging system.

make a stored proc that will read a value from a table.

you cant push updates to machines, but you can poll/pull this field without
tying up too much cpu

how many users are you supporting?

are you sure you wouldnt rather do this with email?
 
Back
Top