Solved

Notification from SQL Server to my App

Posted on 2013-01-14
6
161 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
  • 3
  • 2
6 Comments
 
LVL 29

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 69

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
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 

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 69

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

895 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now