473,418 Members | 3,795 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,418 software developers and data experts.

SQL Query Complete and Tone Internal PC Speaker

Hi,

I am running SQL 2005 Server with SQL Server Management Studio Express 2005. I am aware of the option "Play the Windows default beep when a query batch completes". However, the machine itself (the PC) does not have speakers connected and do not want to attach any speakers.

Has anyone ever found some code that detects a Windows Message (WM_) or otherwise some kind of a hook that detects when a query is complete in Studio Express?

[EDIT:]
The server shares keyboard, monitor and mouse via a KVM box with a half dozen other machines. So even though I may be sitting right next to the server, there's no audio device on the server other than the internal PC speaker.

[EDIT:]
The focus of the question is how to detect when any Query has completed when run from Management Studio Express. Once I can detect this, I can write my code to play a sound on the PC internal speaker.

--
SQL 2005 Server
SQL Server Managment Studio Express 2005
Windows 2003
VS 2008
.NET/C#/C++/VB
May 29 '10 #1
2 2246
Your machine does not have any Speaker, then what do you want to happen when query completes.. You want a mail or ...what ??
May 30 '10 #2
Hi "somdutt";

No, there's no speaker other than the internal PC speaker. That's why I am looking to do this.

The server shares keyboard, monitor and mouse via a KVM box with a half dozen other machines. So even though I may be sitting right next to the server, there's no sound other than the internal PC speaker.

No, I don't want email. I do email notification from stored procedures that I run on a daily basis.

As I explained, I am looking to detect when a query (ad hoc query) is complete. From there, I can write the code to play a tone on the PC internal speaker.

So the focus is on detecting the query complete.
May 30 '10 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: a.dheeraj.kumar | last post by:
How to play wav files through the internal speaker?
11
by: MLH | last post by:
I have a query field... Description: & "2-tone" When I run it, the output in that field is empty. If I change the name to MyDescription - it works fine. I noticed the query field has a...
2
by: John S. Ford, MD | last post by:
I'm familiar with the beep function but is there any function that enables you to determine the pitch and duration of a tone produced by the computer's speaker? John
0
by: Kenneth H. Young | last post by:
I am having difficulties with an LDAP client I'm writing. What I have discovered causes the error is when the client queries the LDAP server and a record contains two values entered in one field...
5
by: parwal.sandeep | last post by:
Hello grp! i'm using INNODB tables which are using frequently . if i fire a SELECT query which fetch major part of table it usually take 10-20 seconds to complete. in mean time if any UPDATE...
3
by: mkjets | last post by:
I have worked for hours on trying to find a solution and have not figured it out. I am working in Access 2003. I need to create a query that takes values from 1 table and displays them in...
6
by: OldBirdman | last post by:
I don't really know how to state this problem, as it doesn't make any sense to me. I have a simple "One-to-Many" query, and was updating the Many side. It quit working. I cannot make any changes...
11
by: fireman87 | last post by:
Hi, Can anyone tell me how I can generate a tone in VB6 I need to be able to set the frequency and duration in ms it also needs to go to the line out or speaker out of the sound card. I have...
4
by: =?Utf-8?B?V29ua28gdGhlIFNhbmU=?= | last post by:
Hello, This is for a WPF (3.5) application. We have a requirement to produce sounds on an internal speaker (in the case that no external sound device is available). I know of...
1
by: anastasio86 | last post by:
Hi, I want to find the way to make a query that when the user runs it and enter no value, the applicacation inserts the default value. For example, the query asks to give a certain time period...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.