• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 262
  • Last Modified:

sql server to cause a pop-up

is there any feature in sql server to cause a pop-up to the user.?

(if the user interface created a specific data change, then give a pop up message?)

thanks
0
25112
Asked:
25112
4 Solutions
 
HaslerctCommented:
, I'm not aware of such features available. Ms SQL is a database server(backend), normally you will have a front-end to extract/update the DB (application or web interface). Thus, you should explorer if your front end app can do such function.
0
 
Chris LuttrellSenior Database ArchitectCommented:
No, there is nothing built into SQL Server itself to create popups.  An application has to be written to do that in some other language.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I agree.
Only in the reporting module you have such a feature.
0
 
Ross TurnerManagement Information Support AnalystCommented:
If you could grab the windows login / machine name which updates you could create a stored procedure to then fire net send via the xp_cmdshell to that user.

Example:
EXEC xp_cmdshell 'net send /domain:SQL_USERS ''SQL Server 
    shutting down in 10 minutes. No more connections 
    allowed.', no_output

Open in new window


http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/net_send.mspx?mfr=true

This might get you sorted :)
0
 
25112Author Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now