Vista - Implementing Sql Object Dependency?

12-28-2008

If there was no such technology like MSMQ how would you try to
implement an sql server object dependency in your windows forms
application? Say I just want to keep updated with the information in a
particular table.

--deostroll

12-28-2008

"deostroll" <deostroll@xxxxxx> wrote in message
news:4f0d534d-4786-4aa4-8d2e-ada009d630b4@xxxxxx

Quote:

> If there was no such technology like MSMQ how would you try to
> implement an sql server object dependency in your windows forms
> application? Say I just want to keep updated with the information in a
> particular table.
>
> --deostroll

Maybe by periodically polling or via another eventing mechanism (Remoting,
COM, WMI).

12-29-2008

Use the Service Broker in SQL Server. It is basically MSMQ in SQL Server.
Check it out, it is pretty cool and functional.

"deostroll" <deostroll@xxxxxx> wrote in message
news:4f0d534d-4786-4aa4-8d2e-ada009d630b4@xxxxxx

Quote:

> If there was no such technology like MSMQ how would you try to
> implement an sql server object dependency in your windows forms
> application? Say I just want to keep updated with the information in a
> particular table.
>
> --deostroll

12-29-2008

We use this to essentially do the same thing, except that we are ending
messages to keep a second database not an application in sync. This has been
in our prod environment for over a year now, I would recomend it.

"Dan Ruehle" wrote:

Quote:

> Use the Service Broker in SQL Server. It is basically MSMQ in SQL Server.
> Check it out, it is pretty cool and functional.
>
> "deostroll" <deostroll@xxxxxx> wrote in message
> news:4f0d534d-4786-4aa4-8d2e-ada009d630b4@xxxxxx

Quote:

> > If there was no such technology like MSMQ how would you try to
> > implement an sql server object dependency in your windows forms
> > application? Say I just want to keep updated with the information in a
> > particular table.
> >
> > --deostroll

>
>

12-30-2008

On Dec 29, 10:27*am, "Dan Ruehle" <d...@xxxxxx> wrote:

Quote:

> Use the Service Broker in SQL Server. *It is basically MSMQ in SQL Server.
> Check it out, it is pretty cool and functional.
>
> "deostroll" <deostr...@xxxxxx> wrote in message
>
> news:4f0d534d-4786-4aa4-8d2e-ada009d630b4@xxxxxx
>
>
>

Quote:

> > If there was no such technology like MSMQ how would you try to
> > implement an sql server object dependency in your windows forms
> > application? Say I just want to keep updated with the information in a
> > particular table.

>

Quote:

> > --deostroll- Hide quoted text -

>
> - Show quoted text -

Is this available for sql server 2000?

12-30-2008

No, it is not. It is a new feature in SQL Server 2005.

"deostroll" <deostroll@xxxxxx> wrote in message
news:7b4ed30b-3971-4529-9909-ef182f934ecc@xxxxxx

Quote:

> On Dec 29, 10:27 am, "Dan Ruehle" <d...@xxxxxx> wrote:

Quote:

>> Use the Service Broker in SQL Server. It is basically MSMQ in SQL
>> Server.
>> Check it out, it is pretty cool and functional.
>>
>> "deostroll" <deostr...@xxxxxx> wrote in message
>>
>> news:4f0d534d-4786-4aa4-8d2e-ada009d630b4@xxxxxx
>>
>>
>>

Quote:

>> > If there was no such technology like MSMQ how would you try to
>> > implement an sql server object dependency in your windows forms
>> > application? Say I just want to keep updated with the information in a
>> > particular table.

>>

Quote:

>> > --deostroll- Hide quoted text -

>>
>> - Show quoted text -

>
> Is this available for sql server 2000?

12-28-2008	#1 (permalink)
deostroll n/a posts	Implementing Sql Object Dependency? If there was no such technology like MSMQ how would you try to implement an sql server object dependency in your windows forms application? Say I just want to keep updated with the information in a particular table. --deostroll
My System Specs

12-28-2008	#2 (permalink)
Joris van Lier n/a posts	Re: Implementing Sql Object Dependency? "deostroll" <deostroll@xxxxxx> wrote in message news:4f0d534d-4786-4aa4-8d2e-ada009d630b4@xxxxxx Quote: > If there was no such technology like MSMQ how would you try to > implement an sql server object dependency in your windows forms > application? Say I just want to keep updated with the information in a > particular table. > > --deostroll Maybe by periodically polling or via another eventing mechanism (Remoting, COM, WMI).
My System Specs

12-29-2008	#3 (permalink)
Dan Ruehle n/a posts	Re: Implementing Sql Object Dependency? Use the Service Broker in SQL Server. It is basically MSMQ in SQL Server. Check it out, it is pretty cool and functional. "deostroll" <deostroll@xxxxxx> wrote in message news:4f0d534d-4786-4aa4-8d2e-ada009d630b4@xxxxxx Quote: > If there was no such technology like MSMQ how would you try to > implement an sql server object dependency in your windows forms > application? Say I just want to keep updated with the information in a > particular table. > > --deostroll
My System Specs

12-29-2008	#4 (permalink)
wdudek n/a posts	Re: Implementing Sql Object Dependency? We use this to essentially do the same thing, except that we are ending messages to keep a second database not an application in sync. This has been in our prod environment for over a year now, I would recomend it. "Dan Ruehle" wrote: Quote: > Use the Service Broker in SQL Server. It is basically MSMQ in SQL Server. > Check it out, it is pretty cool and functional. > > "deostroll" <deostroll@xxxxxx> wrote in message > news:4f0d534d-4786-4aa4-8d2e-ada009d630b4@xxxxxx Quote: > > If there was no such technology like MSMQ how would you try to > > implement an sql server object dependency in your windows forms > > application? Say I just want to keep updated with the information in a > > particular table. > > > > --deostroll > >
My System Specs

12-30-2008	#5 (permalink)
deostroll n/a posts	Re: Implementing Sql Object Dependency? On Dec 29, 10:27am, "Dan Ruehle" <d...@xxxxxx> wrote: Quote: > Use the Service Broker in SQL Server. It is basically MSMQ in SQL Server. > Check it out, it is pretty cool and functional. > > "deostroll" <deostr...@xxxxxx> wrote in message > > news:4f0d534d-4786-4aa4-8d2e-ada009d630b4@xxxxxx > > > Quote: > > If there was no such technology like MSMQ how would you try to > > implement an sql server object dependency in your windows forms > > application? Say I just want to keep updated with the information in a > > particular table. > Quote: > > --deostroll- Hide quoted text - > > - Show quoted text - Is this available for sql server 2000?
My System Specs

12-30-2008	#6 (permalink)
Dan Ruehle n/a posts	Re: Implementing Sql Object Dependency? No, it is not. It is a new feature in SQL Server 2005. "deostroll" <deostroll@xxxxxx> wrote in message news:7b4ed30b-3971-4529-9909-ef182f934ecc@xxxxxx Quote: > On Dec 29, 10:27 am, "Dan Ruehle" <d...@xxxxxx> wrote: Quote: >> Use the Service Broker in SQL Server. It is basically MSMQ in SQL >> Server. >> Check it out, it is pretty cool and functional. >> >> "deostroll" <deostr...@xxxxxx> wrote in message >> >> news:4f0d534d-4786-4aa4-8d2e-ada009d630b4@xxxxxx >> >> >> Quote: >> > If there was no such technology like MSMQ how would you try to >> > implement an sql server object dependency in your windows forms >> > application? Say I just want to keep updated with the information in a >> > particular table. >> Quote: >> > --deostroll- Hide quoted text - >> >> - Show quoted text - > > Is this available for sql server 2000?
My System Specs

Similar Threads
Thread	Forum
Implementing the Factory pattern	.NET General
implementing get-item	PowerShell
Implementing Unmanaged Interface in C#	.NET General
Implementing SMO in Powershell	PowerShell
Adding canonical aliases for Compare-Object, Measure-Object, New-Object	PowerShell