Solved

sql server to cause a pop-up

Posted on 2013-01-18
5
255 Views
Last Modified: 2013-01-25
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
Comment
Question by:25112
5 Comments
 
LVL 4

Assisted Solution

by:Haslerct
Haslerct earned 125 total points
ID: 38795588
, 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
 
LVL 26

Assisted Solution

by:Chris Luttrell
Chris Luttrell earned 125 total points
ID: 38795714
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
 
LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 125 total points
ID: 38796165
I agree.
Only in the reporting module you have such a feature.
0
 
LVL 7

Accepted Solution

by:
Ross Turner earned 125 total points
ID: 38797216
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
 
LVL 5

Author Comment

by:25112
ID: 38819281
thanks
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question