SQL 2000 and .NET events - .NET Framework

jabailo

Can a SQL 2000 server raise a .NET event?

--
Texeme Textcasting Technology
http://www.texeme.com

Jul 21 '05 #1

Subscribe Reply

1311

Mario

be more clear

"ja*****@texeme .com" wrote:

Can a SQL 2000 server raise a .NET event?

--
Texeme Textcasting Technology
http://www.texeme.com

Jul 21 '05 #2

jabailo

Mario wrote:

On SQL Server, you have 'events', sort of, in the form of triggers. When
someone inserts a record, other things can happen.

In Remoting, I can raise events on a server which can raise events on my
windows clients.

So, I am thinking, I should be able to set up a trigger, that runs a
program, that sends a message to a Remoted server, and which then notifies
my clients that something on the database has changed.

My question is, does .NET integrate enough with SQL server so that I am able
to do this? My clumsy way would be to let the trigger run a stored
procedure that runs a console application in DOS.

be more clear

"ja*****@texeme .com" wrote:

Can a SQL 2000 server raise a .NET event?

--
Texeme Textcasting Technology
http://www.texeme.com

--
Texeme Textcasting Technology
http://www.texeme.com

Jul 21 '05 #3

Carlos Lopes

Mario,

i don't think you can do it with SqlServer 2000, but you can do it with Sql
Server 2005 and VS 2005.

"ja*****@texeme .com" wrote:

Mario wrote:

On SQL Server, you have 'events', sort of, in the form of triggers. When
someone inserts a record, other things can happen.

In Remoting, I can raise events on a server which can raise events on my
windows clients.

So, I am thinking, I should be able to set up a trigger, that runs a
program, that sends a message to a Remoted server, and which then notifies
my clients that something on the database has changed.

My question is, does .NET integrate enough with SQL server so that I am able
to do this? My clumsy way would be to let the trigger run a stored
procedure that runs a console application in DOS.

be more clear

"ja*****@texeme .com" wrote:

Can a SQL 2000 server raise a .NET event?

--
Texeme Textcasting Technology
http://www.texeme.com

--
Texeme Textcasting Technology
http://www.texeme.com

Jul 22 '05 #4

Similar topics

7394

How Do I Prevent SQL 2000 From Posting This Message To The Event Viewer - Application Log

by: Mike | last post by:

How do I prevent SQL Server 2000 from posting successful backup completion messages to the Windows 2000 Application Event Log? I have scheduled jobs which backup my transaction logs on 50+ databases and it always writes to the Windows 2000 application event log upon completion. Due to the frequency of the jobs it only takes a day for the Application Log to fill up, which is causing other jobs to get hung up when trying to write to it. On...

Microsoft SQL Server

5266

Creating Option Buttons or check boxes with Access 2000 using VB

by: Ben | last post by:

My current project requires me to create part of a form that is created on the fly. The project consists a list of entries to an event. The name and address and such is easy. The design is detup so that the creater of the even can make their own event in the database. When they do so a 2 tables are created. One for the entries such as names and the other is for the parameters of each event. The creator then goes in and makes each event...

Microsoft Access / VBA

4750

Error Trapping In Access 2000

by: Peter Frost | last post by:

Please help I don't know if this is possible but what I would really like to do is to use On Error Goto to capture the code that is being executed when an error occurs. Any help would be much appreciated. Thanks in advance

Microsoft Access / VBA

2033

Access 2000 Form Does Not Return Data After Upsize to Project

by: David C. Barber | last post by:

upsized an MDB to ADP/SQL Server 2000 under Access 2000. All the DAO code that I've changed to ADO code is working fine, HOWEVER the form Record Source itself does not seem willing to return data. I've set the Record Source to both the query, and the SQL contained within the query, and although the system pauses long enough to have gone out and retrieved the data, I can't see it. The form itself remains gray. In addition: ...

Microsoft Access / VBA

2151

Automating Outlook 2000

by: Richard | last post by:

All, I am writing an Outlook 2000 Add-In .DLL program. I have applied the necessary knowledge base fixes to enable event handling in Outlook 2000 and everything is working except for one thing: When I make changes to the items in a folder I get the ItemAdd() event and the ItemChange() event but I do not ever get the ItemRemove() event.

C# / C Sharp

364

SQL 2000 and .NET events

by: jabailo | last post by:

Can a SQL 2000 server raise a .NET event? -- Texeme Textcasting Technology http://www.texeme.com

.NET Framework

2058

SQL Server 2000 Audit for login

by: Jacand4321 | last post by:

Is there a way to audit the login on SQL Server 2000? I'm looking for a way to get a report login/logout events with the name of the database. Thanks in advance.

Microsoft SQL Server

1111

VB.net calendar showing events from sql 2000 db

by: rjszum | last post by:

Hello, Could someone point me in the right direction. I want to use a calendar control and show events in the calendar for each date. These events would come from a sql 2000 db. So looking at the web page calendar you could see all events for the whole month and which day they are releted to. I need this in vb.net not c#. Thanks.

.NET Framework

3497

SQL 2000 SP4 and SQL 2005 Express Co-Exist?

by: wajackson | last post by:

I recently installed SQL 2005 Express on a SBS 2003 Server that is running SQL 2000. Here's the events and the question I need help with: 1) After the successful installation of SQL 2005 Express and the Management Studio, I attached an existing 2000 Database. 2) I created a new Database in the Management Studio 3) I created a SQL script that created a 'Copy' of a Table in the SQL 2000 database and it ran successfully.

Microsoft SQL Server

8946

What is ONU?

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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9236

The easy way to turn off automatic updates for Windows 10/11

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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9182

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

8186

AI Job Threat for Devs

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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6031

Couldn’t get equations in html when convert word .docx file to html file in C#.

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 then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4550

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

3261

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2724

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2180

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General