Receiving a message with a specific contract

If the service is defined with multiple contracts is there a way to receive a message with a specific contract?

No. I'm curious to understand why do you want this, can you give a bit of detail?

Thanks,
~ Remus

|||

I am implementing a queue processing system. You can get some of the info here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=446600&SiteID=1. The queue can contain messages of different contracts/types. When I receive a message I instantiate a different processing component based on the contract/type of the message. There are processing servers that process different kind of messages. The single processing server might only have a subset of processing components. This is why I need a way to retrieve messages based on the contract/type.

Alex

|||

You can try having one service as front end that simply forwards each dialog to specialized services on the back end, similar to the approach described here: https://blogs.msdn.com/remusrusanu/archive/2006/03/28/563571.aspx

Each supported contract would be forwarded to a different service.

HTH,
~ Remus

|||

I have a working implementation without Service Broker which handles message types and message priority (another one Service Broker does not handle directly). It does not make sence to switch to Service Broker which would also require to increse the complexity of the architecture.

Alex

receive notification from server in application

Hello, I have an application which is running on multiple computers and is connected with one sql server. I would like to that the user is notified when another user is performing some special action. So I thought that when this action begins, the server is notified either by writing some data in a table or something like this. Then I would like other applications to be notified so is possible that notification service notifies the application? If yes how? ThanksSSNS may be used in instances like this.

If your "special actions" are not recognizable using the built-in event providers (SQL Server Event Provider & File System Event Provider), you'll need to create a custom event provider to gather the event data.

Assuming the criteria by which people want to be notified is fairly static, you can create subscriptions to match upon. SSNS is not a good choice if the criteria changes frequently (for example, I want to notified when the data behind the web page I'm looking at happens to change. People may bounce among web pages frequently so SSNS is not a good choice there.)

You'll definitely need to create a custom delivery protocol (and perhaps a custom content formatter too) to get the notification to the application.

BTW - you may also want to check out Query Notifications. That technology may offer some of the features you are looking for.

HTH...

Joe|||I want the users of the application to be notified when a particular field in particular table changes. How can the server find all the instances of my application that are connected to it and how can it send the information? How can my application receive them? Thanks

receive notification from server in application

Hello, I have an application which is running on multiple computers and is connected with one sql server. I would like to that the user is notified when another user is performing some special action. So I thought that when this action begins, the server is notified either by writing some data in a table or something like this. Then I would like other applications to be notified so is possible that notification service notifies the application? If yes how? Thanks
SSNS may be used in instances like this.

If your "special actions" are not recognizable using the built-in event providers (SQL Server Event Provider & File System Event Provider), you'll need to create a custom event provider to gather the event data.

Assuming the criteria by which people want to be notified is fairly static, you can create subscriptions to match upon. SSNS is not a good choice if the criteria changes frequently (for example, I want to notified when the data behind the web page I'm looking at happens to change. People may bounce among web pages frequently so SSNS is not a good choice there.)

You'll definitely need to create a custom delivery protocol (and perhaps a custom content formatter too) to get the notification to the application.

BTW - you may also want to check out Query Notifications. That technology may offer some of the features you are looking for.

HTH...

Joe|||I want the users of the application to be notified when a particular field in particular table changes. How can the server find all the instances of my application that are connected to it and how can it send the information? How can my application receive them? Thanks

Receive multiple FTP files

Is there a way to get more than one file with a single ftp task in SQL 2005?

I need to get 5 files from one server. They are in two different directories is that makes any difference. Right now I have a separate task for each but would like to have one task if possible.

Thanks

You can use a wild card (*) in your path... If you can't use a wild card to get your 5 files, then you'll have to split up the tasks.|||

I figured something like that would be the answer...

Thats ok though... Thanks for the response.

|||

Bill, we actually use a table for our connection (directories, files, etc.) for FTP's and loop through the table replacing the FTP properties (in the FTP task) with the info from the table. If you did this, you could read the connection info into a recordset. Add a ForEach task and place the FTP task within the ForEach container.

The recordset info then drives the connection info for the FTP task... Since you mention two directories, you could use a row for each directory. Lots cleaner (and easier to maintain!) than having five separate FTP tasks firing...

sql

Rebuilding master with multiple instances

When having to rebuild the master database (using SQL 2K), and their is
more than one instance of SQL Server running, how do you specify the
appropriate instance to rebuild?
Message posted via http://www.sqlmonster.com
I believe SERVER is one of the parameters.
Sincerely,
Anthony Thomas

"Robert Richards via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:4d7df593846d4924bd55c0797e2e9544@.SQLMonster.c om...
When having to rebuild the master database (using SQL 2K), and their is
more than one instance of SQL Server running, how do you specify the
appropriate instance to rebuild?
Message posted via http://www.sqlmonster.com

Rebuilding master with multiple instances

When having to rebuild the master database (using SQL 2K), and their is
more than one instance of SQL Server running, how do you specify the
appropriate instance to rebuild?
Message posted via http://www.droptable.comI believe SERVER is one of the parameters.
Sincerely,
Anthony Thomas
"Robert Richards via droptable.com" <forum@.droptable.com> wrote in message
news:4d7df593846d4924bd55c0797e2e9544@.SQ
droptable.com...
When having to rebuild the master database (using SQL 2K), and their is
more than one instance of SQL Server running, how do you specify the
appropriate instance to rebuild?
Message posted via http://www.droptable.com

Rebuilding master with multiple instances

When having to rebuild the master database (using SQL 2K), and their is
more than one instance of SQL Server running, how do you specify the
appropriate instance to rebuild?
--
Message posted via http://www.sqlmonster.comI believe SERVER is one of the parameters.
Sincerely,
Anthony Thomas
"Robert Richards via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:4d7df593846d4924bd55c0797e2e9544@.SQLMonster.com...
When having to rebuild the master database (using SQL 2K), and their is
more than one instance of SQL Server running, how do you specify the
appropriate instance to rebuild?
--
Message posted via http://www.sqlmonster.comsql

Rebuild master database failed

Tried to rebuild the master database in SQL server 2000, failed multiple times with "error -1".
We used the /binn/rebuildm.exe to do that. The read attribute is not an issue.
Need help!Remove the SQL Server and also registry referenced keys, reboot the box and resinstall the SQL Server. It may be issue with OS sometimes.

Reason for multiple filegroups/ files?

SQL2K
SP4
If my data is spread accross a Raid array, is there any real reason to use
multiple filegroups/ files? Will I see any performance benefit? Will I only
see it on VLDB's. If I do use them, is there a good way to group them
logically?
TIA, ChrisRChrisR
>Will I see any performance benefit?
Probably, if you put the filegroup on another PHYSICAL disk
>Will I only
> see it on VLDB's. If I do use them, is there a good way to group them
> logically?
Yes , it makes sence only for VLDB
Look, you will have to investigate it carefuly, I mean how you are going
to restore in case of failure or somethinmg like that , it is not so easy
to maintain and I have my doubt that nowadays we can really gain
perfiomance benefit from creating a new file group . Perhaps you might
think about adding a new datafile .NDF and seeing how it works
"ChrisR" <noFudgingWay@.NoEmail.com> wrote in message
news:%23hGlHLPKHHA.1912@.TK2MSFTNGP03.phx.gbl...
> SQL2K
> SP4
> If my data is spread accross a Raid array, is there any real reason to use
> multiple filegroups/ files? Will I see any performance benefit? Will I
> only
> see it on VLDB's. If I do use them, is there a good way to group them
> logically?
> TIA, ChrisR
>|||Add on ; please take a look into below URL's. But to make use of the full
advantage you may need multiple disk controller as Uri suggested.
http://www.databasejournal.com/features/mssql/article.php/1439801
http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=42&rl=1
Thanks
Hari
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:u4aAfSPKHHA.3936@.TK2MSFTNGP02.phx.gbl...
> ChrisR
>>Will I see any performance benefit?
> Probably, if you put the filegroup on another PHYSICAL disk
>>Will I only
>> see it on VLDB's. If I do use them, is there a good way to group them
>> logically?
> Yes , it makes sence only for VLDB
>
> Look, you will have to investigate it carefuly, I mean how you are going
> to restore in case of failure or somethinmg like that , it is not so easy
> to maintain and I have my doubt that nowadays we can really gain
> perfiomance benefit from creating a new file group . Perhaps you might
> think about adding a new datafile .NDF and seeing how it works
>
>
> "ChrisR" <noFudgingWay@.NoEmail.com> wrote in message
> news:%23hGlHLPKHHA.1912@.TK2MSFTNGP03.phx.gbl...
>> SQL2K
>> SP4
>> If my data is spread accross a Raid array, is there any real reason to
>> use
>> multiple filegroups/ files? Will I see any performance benefit? Will I
>> only
>> see it on VLDB's. If I do use them, is there a good way to group them
>> logically?
>> TIA, ChrisR
>>
>|||At the very least I always recommend creating one secondary filegroup to
place all the user objects and leave just the system objects in the primary
filegroup. This makes it cleaner and easier to do piecemeal restores if
needed. From there it depends on how you use your data and what your
hardware config is like. If you want to separate different groups of objects
such as Non-clustered indexes from the Clustered / tables onto different
drive arrays you need at least two filegroups. If you know this is something
you may do in the future but aren't now it still may make sense to separate
them into multiple FG's to make the move easier down the road. If the db is
relatively small, your hardware is decent you may never see any advantages
of multiple files or filegroups.
--
Andrew J. Kelly SQL MVP
"ChrisR" <noFudgingWay@.NoEmail.com> wrote in message
news:%23hGlHLPKHHA.1912@.TK2MSFTNGP03.phx.gbl...
> SQL2K
> SP4
> If my data is spread accross a Raid array, is there any real reason to use
> multiple filegroups/ files? Will I see any performance benefit? Will I
> only
> see it on VLDB's. If I do use them, is there a good way to group them
> logically?
> TIA, ChrisR
>|||Thanks everyone, this is all as I suspected.
"ChrisR" <noFudgingWay@.NoEmail.com> wrote in message
news:%23hGlHLPKHHA.1912@.TK2MSFTNGP03.phx.gbl...
> SQL2K
> SP4
> If my data is spread accross a Raid array, is there any real reason to use
> multiple filegroups/ files? Will I see any performance benefit? Will I
only
> see it on VLDB's. If I do use them, is there a good way to group them
> logically?
> TIA, ChrisR
>