|
|
You're in the
sql server notification services
group:Can I have Multiple HostedProviders.
sql server notification services:
Your first question should be possible - you can have as many hosted providers that you want, and they can all submit the same event type. You just need to look at creating hosted event providers in the books online, and then use that info to create 2 hosted providers - should be straight forward. Your second question about executing stuff in a seperate database is interesting to me - we had similar issues. I believe you can use a syntax similar to the one you specified, assuming that the correct permissions are set. I needed to do LOT of interaction with our apps database, so I have decided to host the SSNS database tables inside my pre-existing database, which is very useful indeeed! You can only do this with SSNS 2005 though I believe. Hope thats of use! Matt Roberts [quoted text, click to view] > Hi All, > > I would like to know if we can have multiple "HostedProvider"(s) for a > single "Events" Class in the Notification Services 2005. If so, how do > I implement the same. > > Also How can execute a stored procedure residing in a different > Database, in my Notification Services Application, Is it ok to use the > four part naming convention i.e, > "<Databasename>.<Username>.<StoredProcedureName>" or there is some > other way to invoke the same. > > Thanks in Advance. > > Shashidhara K >
Hi All,
I would like to know if we can have multiple "HostedProvider"(s) for a single "Events" Class in the Notification Services 2005. If so, how do I implement the same. Also How can execute a stored procedure residing in a different Database, in my Notification Services Application, Is it ok to use the four part naming convention i.e, "<Databasename>.<Username>.<StoredProcedureName>" or there is some other way to invoke the same. Thanks in Advance.
Thank you Matt. But I still would require more information on
HostedProvider(s) as, the event provider is not firing the events, and the Profiler trace shows no trace of these events being fired. So, it would be of great help if I could get some more information on it. Also I would like to bring to your notice that I have declared multiple HostedProviders in the ADF File, So would that cause any problems. Thanks in advance, Shashidhara K [quoted text, click to view] "matt roberts" wrote:
> Hello Shashidhara, > > Your first question should be possible - you can have as many hosted providers > that you want, and they can all submit the same event type. You just need > to look at creating hosted event providers in the books online, and then > use that info to create 2 hosted providers - should be straight forward. > > Your second question about executing stuff in a seperate database is interesting > to me - we had similar issues. I believe you can use a syntax similar to > the one you specified, assuming that the correct permissions are set. I needed > to do LOT of interaction with our apps database, so I have decided to host > the SSNS database tables inside my pre-existing database, which is very useful > indeeed! You can only do this with SSNS 2005 though I believe. > > Hope thats of use! > > Matt Roberts > > > > > Hi All, > > > > I would like to know if we can have multiple "HostedProvider"(s) for a > > single "Events" Class in the Notification Services 2005. If so, how do > > I implement the same. > > > > Also How can execute a stored procedure residing in a different > > Database, in my Notification Services Application, Is it ok to use the > > four part naming convention i.e, > > "<Databasename>.<Username>.<StoredProcedureName>" or there is some > > other way to invoke the same. > > > > Thanks in Advance. > > > > Shashidhara K > > > >
If you're using SQL 2005, remember the username is no longer tied to
the schema, so your syntax would be: <Databasename>.<SchemaName>.<StoredProcedureName> You can definitely reference a different database on the same server or another server. Setup a linked server to get to other SQL instances on other SQL Servers. Then your syntax would be: <LinkedServer>.<Databasename>.<SchemaName>.<StoredProcedureName> [quoted text, click to view] matt roberts wrote:
> Hello Shashidhara, > > I'm pretty new myself to a lot of SSNS stuff - so I can't really help you > on those specific problems - hopefully someone else can provide you with > some info? > > > > Thank you Matt. But I still would require more information on > > HostedProvider(s) as, the event provider is not firing the events, and > > the Profiler trace shows no trace of these events being fired. So, it > > would be of great help if I could get some more information on it. > > Also I would like to bring to your notice that I have declared > > multiple HostedProviders in the ADF File, So would that cause any > > problems. > > > > Thanks in advance, > > Shashidhara K > > "matt roberts" wrote: > > > >> Hello Shashidhara, > >> > >> Your first question should be possible - you can have as many hosted > >> providers that you want, and they can all submit the same event type. > >> You just need to look at creating hosted event providers in the books > >> online, and then use that info to create 2 hosted providers - should > >> be straight forward. > >> > >> Your second question about executing stuff in a seperate database is > >> interesting to me - we had similar issues. I believe you can use a > >> syntax similar to the one you specified, assuming that the correct > >> permissions are set. I needed to do LOT of interaction with our apps > >> database, so I have decided to host the SSNS database tables inside > >> my pre-existing database, which is very useful indeeed! You can only > >> do this with SSNS 2005 though I believe. > >> > >> Hope thats of use! > >> > >> Matt Roberts > >> > >>> Hi All, > >>> > >>> I would like to know if we can have multiple "HostedProvider"(s) for > >>> a single "Events" Class in the Notification Services 2005. If so, > >>> how do I implement the same. > >>> > >>> Also How can execute a stored procedure residing in a different > >>> Database, in my Notification Services Application, Is it ok to use > >>> the four part naming convention i.e, > >>> "<Databasename>.<Username>.<StoredProcedureName>" or there is some > >>> other way to invoke the same. > >>> > >>> Thanks in Advance. > >>> > >>> Shashidhara K > >>>
Another thing regarding your events firing. Check the Windows event
log on your generator/distributor machine and see if you have any errors, and post back.
Hello Shashidhara,
I'm pretty new myself to a lot of SSNS stuff - so I can't really help you on those specific problems - hopefully someone else can provide you with some info? [quoted text, click to view] > Thank you Matt. But I still would require more information on > HostedProvider(s) as, the event provider is not firing the events, and > the Profiler trace shows no trace of these events being fired. So, it > would be of great help if I could get some more information on it. > Also I would like to bring to your notice that I have declared > multiple HostedProviders in the ADF File, So would that cause any > problems. > > Thanks in advance, > Shashidhara K > "matt roberts" wrote: > >> Hello Shashidhara, >> >> Your first question should be possible - you can have as many hosted >> providers that you want, and they can all submit the same event type. >> You just need to look at creating hosted event providers in the books >> online, and then use that info to create 2 hosted providers - should >> be straight forward. >> >> Your second question about executing stuff in a seperate database is >> interesting to me - we had similar issues. I believe you can use a >> syntax similar to the one you specified, assuming that the correct >> permissions are set. I needed to do LOT of interaction with our apps >> database, so I have decided to host the SSNS database tables inside >> my pre-existing database, which is very useful indeeed! You can only >> do this with SSNS 2005 though I believe. >> >> Hope thats of use! >> >> Matt Roberts >> >>> Hi All, >>> >>> I would like to know if we can have multiple "HostedProvider"(s) for >>> a single "Events" Class in the Notification Services 2005. If so, >>> how do I implement the same. >>> >>> Also How can execute a stored procedure residing in a different >>> Database, in my Notification Services Application, Is it ok to use >>> the four part naming convention i.e, >>> "<Databasename>.<Username>.<StoredProcedureName>" or there is some >>> other way to invoke the same. >>> >>> Thanks in Advance. >>> >>> Shashidhara K >>>
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |