Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 how to find updating a record in .net

Author  Topic 

saeedeh
Starting Member

2 Posts

Posted - 2007-09-23 : 02:25:08
Hello
I need an alarm or raise an event from SQL Server after updating to get it in .net.
I use SQL Server 2005 Express Edition and vb.net2 for my programming language.
Suppose that in a windows form I have a grid and I'm working with this page
another client is working with this same page .He is editing the information of
a record of a grid and save it in database so I want to give an alarm or an event
that raise from SQL Server (for example in a trigger) , what can I do?
Thanks.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-23 : 17:28:11
You can find how to create trigger in sql books online.
Go to Top of Page

saeedeh
Starting Member

2 Posts

Posted - 2007-09-24 : 07:50:18
thanks for your answer but I don't know how to alarm or raise an event in sql and get it in .net I mean i don't know what I should write in my trigger
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-09-24 : 10:51:00
you can use query notifications:
http://www.simple-talk.com/sql/sql-server-2005/using-and-monitoring-sql-2005-query-notification/

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com
Go to Top of Page
   

- Advertisement -