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

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
 
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Call SP from command button 4
Microsoft Calendar Printing Assistance Outlook 2007 1
EXEC SP from Button 1
Calculating Meal Period Violations in Access 2
How do I set default time interval on all exchange calendars from 30 min to 15 min ? 0
Behavior use problem 0
Cannot Execute SP From Windows XP Machine 7
Reminders out of sync depending on the view 2

Top