473,651 Members | 2,635 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Anyone out there using this? It's fabulous.



I mean the ability to call a Web service or a WCF service with Service
Broker using CLR code that's running on SQL server is very good. I am
programming this in a project for a client that's being done at this time.

The ability to have SQL server triggers push things like XML and XML
serialized objects into queues, the Service Broker using CLR to pull things
off the queues, Service Broker using CLR calls a Web service that has access
to the BLL and DAL layers and then in turn the send things off to other SQL
server queues, like using MSMQ. It's like using WCF with end-points and
everything, but it's on SQL Server.

Other processes like a Console or Windows service application running on the
back-end working with the MS SQL server queues is something I didn't know
that could be done, until two weeks ago.

It's fabulous stuff.

http://www.devsource.com/c/a/Using-V...R-Integration/
http://msdn.microsoft.com/en-us/library/ms345108.aspx

Nov 16 '08 #1
2 1092
I don't know what you are talking about, but suppose you send a
message to this Service Broker, turn off your machine, and come back a
week later. Won't it time out? Or will a reply be waiting for you?

Don't really see the utility of this "guarantee" unless you can do the
above.

RL

Mr. Arnold wrote:
Nov 16 '08 #2

"raylopez99 " <ra********@yah oo.comwrote in message
news:e4******** *************** ***********@k24 g2000pri.google groups.com...
>I don't know what you are talking about, but suppose you send a
message to this Service Broker, turn off your machine, and come back a
week later. Won't it time out? Or will a reply be waiting for you?
You don't send messages to the Service Broker. A client application that
uses the SQL Server queues send messages to the queues. One would think that
if the client knows SQL server is down, it won't send anything to the
queues, just as if the application knows that a SQL server table is down and
not to be writing data to tables knowing that it's down.

The data is held in the queues just like it's held in a SQL server table,
until the Service Broker that runs on SQL Server retrieves that data out of
the queue to process it, which transactional queue processing can be done as
well with data being rolled back into the queue, if all transactions in the
queue do not complete in a given transaction.

Also, any application that can access the SQL server can access the queues
to send or receive messgaes by use of T-SQL statements with in-line code or
by using Stored Procedure as well. The data is going to be held in the
queue, until the queue is cleared by a command to clear the queue or a
program retrieves a message off of the queue.
>
Don't really see the utility of this "guarantee" unless you can do the
above.
It's guaranteed if you the developer knows what you are doing. That's the
key.

And I suggest that you go get the book for 2005 that was tossed in may face
and figure it out, because one can use MSMQ, Named Pipes, WCF, .Net
Remoting, and now MS SQL server queues to send messages to other programs
using a queuing process, very powerful stuff.

http://www.amazon.com/Pro-Server-200.../dp/1590599993

I talked with another developer that's showing me what is happening with the
SQL Server Service Broker. He indicates that the solution that now uses SQL
Server Broker has speed-up processing of things a great deal faster now
than before.

My usage of this technology is a communications link between two search
engines that the USAF, other military and DOD personnel are using, along
with other things the solutions are doing. One the USAF already has and
implemented, and the other one it has just purchased to be implemented--
make them communicate, make them work and save data to SQL server on both
sides of the bridge.
Nov 17 '08 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

162
7213
by: Isaac Grover | last post by:
Hi everyone, Just out of curiosity I recently pointed one of my hand-typed pages at the W3 Validator, and my hand-typed code was just ripped to shreds. Then I pointed some major sites (microsoft.com, cnn.com, etc.) at the W3 Validator; to my surprise none of them passed. Doesn't anyone care anymore, or are the standards more-or-less looked at as guidlines for web design?
5
2166
by: Marcin Kalicinski | last post by:
Hi, Because public inheritance should be used to model is-a relationship, is it evil from a design point of view to disallow some operations from base class? class Derived: public Base { /* ... */ private:
3
1817
by: Lord Labakudas | last post by:
Hi, I have the following simple template implementation: // -------------- b.h ----------------- // template <class t> class b { public: b() ;
8
1643
by: Donius | last post by:
Hello! I've been headhunting for a javascript popup that i saw once, that when it's called, pops open and grows from the center to its desired h and w. Does anyone have any idea where i could start on this one? Haven't found through googling or list searching. Thanks! -Brendan
7
3102
by: Tao Wang | last post by:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, I saw cuj's conformance roundup, but the result is quite old. I think many people like me want to know newer c++ standard conformance test result. Especially, I want to know the compiler conformance of vc7.1, vc8.0, gcc 4.x and intel c++, and also each implementation of STL. The world is moving on, right? :)
3
28698
by: Filippo P. | last post by:
Hi there, I have a menu (Collection) that needs to be trimmed based on security access of the logged user. protected void AdjustMenuBasedOnUserSecurity(Items ItemsList) { foreach (Item i in ItemsList) {
12
2892
by: aling | last post by:
Have following code snip: struct struc { int member1; int member2; } ; printf("&((struc*)0)->member2=%p\n", &((struc*)0)->member2); In VC7.1, the output is 4, the offset of member2 in struc.
18
4060
by: Good Man | last post by:
Hi there Just before I sit down and re-invent the wheel, I was wondering if anyone here has coded any Gantt charts (preferably 'week' style as opposed to 'month' style) and might have a class to share? I've checked out phpclasses.org, and nothing quite suits my purposes. I can hack one or two to turn it into what I need, but hey, might as well check here first!
2
1265
by: ManicQin | last post by:
Except Boost I mean. AFAIK major chunks of the new std are already "closed", are there any compiler vendors that are already working on releasing compilers compatible with the new std? I want to "get dirty" with the new std...
2
2376
by: Mr. Arnold | last post by:
I mean the ability to call a Web service or a WCF service with Service Broker using CLR code that's running on SQL server is very good. I am programming this in a project for a client that's being done at this time. The ability to have SQL server triggers push things like XML and XML serialized objects into queues, the Service Broker using CLR to pull things off the queues, Service Broker using CLR calls a Web service that has access to...
0
8347
marktang
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...
0
8792
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8694
jinu1996
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8457
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,...
1
6157
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4143
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...
1
2696
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
1
1905
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1585
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.