SQL 2000 and .NET events

jabailo

Can a SQL 2000 server raise a .NET event?

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

Jul 21 '05 #1

Subscribe Post Reply

1298

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

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+...

Microsoft SQL Server

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...

Microsoft Access / VBA

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...

Microsoft Access / VBA

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....

Microsoft Access / VBA

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...

C# / C Sharp

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

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

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...

.NET Framework

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...

Microsoft SQL Server

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

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...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

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...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

Similar topics