|
|
|
date: Fri, 24 Mar 2006 00:13:04 -0800,
group: microsoft.public.sqlserver.notificationsvcs
back
Re: Can I have Multiple HostedProviders.
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
>
date: Fri, 24 Mar 2006 11:57:13 +0000 (UTC)
author: matt roberts
Re: Can I have Multiple HostedProviders.
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
> >
>
>
>
date: Fri, 24 Mar 2006 05:23:02 -0800
author: Shashidhara
Re: Can I have Multiple HostedProviders.
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
>>>
date: Fri, 24 Mar 2006 13:33:46 +0000 (UTC)
author: matt roberts
Re: Can I have Multiple HostedProviders.
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>
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
> >>>
date: 24 Mar 2006 07:51:43 -0800
author: CoreyB
|
|
