Solved

SQL server 2000 trigger-net send-Windows 7

Posted on 2010-11-22
8
543 Views
Last Modified: 2012-06-21
Hi,
I use SQL Server 2000 and on one table I have trigger with net send message. Since I want to change user OS to Windows 7 I cant use net send any more but I need to have instant information for user when new row is inserted in sql table. What can I use instead of net send on sql server 2000 and windows 7.

Thanks.
0
Comment
Question by:kahvedzic
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 34188282
msg.exe replaces the net send in windows vista/windows 7

hope this helps
0
 
LVL 1

Author Comment

by:kahvedzic
ID: 34188399
not helping, already try thanks anyway.
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 34188535
what exactly is the problem?

is this a sql server on windows 7, or do you want to "net send" to users, which on their turn, are on windows 7 ...
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Author Comment

by:kahvedzic
ID: 34188608
sql server is on Win server 2003, user computer is on Windows 7. Sql Server send (with net send) message to Windows 7 but there is no message on desktop because there is no net send on Windows 7. I want to change the way sql server send message to client and use something instead of net send, some other messaging system.
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 34188673
then, you will need to install some third-party messaging application on both the server and (all) the client PC in question.
I don't have suggestions for that, but you should find one, in conjunction with your (network) admins ...
0
 
LVL 1

Author Comment

by:kahvedzic
ID: 34188726
you mean that I have to use some LAN messenger that will send message after trigger fire.
0
 
LVL 1

Author Comment

by:kahvedzic
ID: 34194407
Which free LAN messenger do you suggest to use?
0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 34194599
>you mean that I have to use some LAN messenger that will send message after trigger fire.
yes

>Which free LAN messenger do you suggest to use?
I repeat:
>I don't have suggestions for that, but you should find one, in conjunction with your (network) admins ...
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL server 2012 BPA and Baseline Configuration Analyzer 2.0 16 29
SQL Syntax 6 27
SQL 2012 Instance Problem 3 36
SQL query 7 10
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup" or a blinking cursor with black screen. A loop for Auto repair will start but fix nothing.  You will be panic as there are no backā€¦
This Micro Tutorial will go in depth within Systems and Security in Windows 7 and will go into detail regarding Action Center, Windows Firewall, System, etc. This will be demonstrated using Windows 7 operating system.
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.

735 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