Solved

Notification from SQL Server to my App

Posted on 2013-01-14
6
171 Views
Last Modified: 2013-01-18
Hello,

I've been using timers to check some object status from a database (SQL Server 2008 Express). It was all ok, until the data retrieved was big enought that the timers routine to check got inefficient.

I read something about SQLDependency, which triggers an event when a table is changed and notifies my app. That seems to be great, since i have to treat the data only when I really have to...

The problem is I'm kind of a rookie in database structuring and the examples I found were rather complex for me...

Could someone post here a very simple example that i can understand how to use this? Or if there is a better way that would be welcome too.

Thanks in advance.
0
Comment
Question by:toddinho
[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
  • 3
  • 2
6 Comments
 
LVL 30

Expert Comment

by:anarki_jimbel
ID: 38776521
There are some examples alreadyon Internet:

http://msdn.microsoft.com/en-us/library/t9x04ed2(v=vs.80).aspx
and related
http://msdn.microsoft.com/en-us/library/9dz445ks(v=vs.80).aspx

The code is pretty simple.
0
 
LVL 70

Accepted Solution

by:
Éric Moreau earned 500 total points
ID: 38776625
0
 

Author Comment

by:toddinho
ID: 38793735
Wow, thats GREAT!!! Thanks for the example emoreau!!

PS: Sorry for the time i took to accept the solution, I couldn't download the .zip from the office, i had to take it home and email it to myself.
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Comment

by:toddinho
ID: 38793738
Just one last question: If i want to drop a database that has these services it says it's in use. How can i delete them so I can drop it?
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 38793749
I never tried. but you should be able to use SP_Kill to kill any session (use SP_who2 to find out the sessions).
0
 

Author Comment

by:toddinho
ID: 38794016
I figured this out... It wasn't the Service Broker that was using the database, i had to set it offline.

alter database [DemoNotifications2]
set OFFLINE
with rollback immediate
go
drop database [DemoNotifications2]
go

Thanks anyway :)
0

Featured Post

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!

Question has a verified solution.

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

In this article I will describe the Backup & Restore 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.
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

688 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