|
Home > Archive > MS SQL Server Notification Services > May 2005 > Index creation
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| I have added index definitions to my ADF file (<IndexSqlSchema> node in
<EventClass> ). However, NS does not create these indexes in my databases. I
checked the Stock sample application and NS doesn't create any indexes there
either. Has anyone an idea how to get NS to create these indexes?
| |
| Joe Webb 2005-05-11, 3:23 am |
| Hi Erick -
Check NSCurrent<EventClass>Events and you'll see your index there.
Rather than directly using the events table, the Generator uses an
internal table called NSCurrent<EventClass>Events. By using that
table, the Generator can work with only the events associated with the
current quantum.
HTH...
--
Joe Webb
SQL Server MVP
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/t...il/-/0972688811
I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
On Tue, 10 May 2005 12:58:03 -0700, "Erick"
<Erick@discussions.microsoft.com> wrote:
>I have added index definitions to my ADF file (<IndexSqlSchema> node in
><EventClass> ). However, NS does not create these indexes in my databases. I
>checked the Stock sample application and NS doesn't create any indexes there
>either. Has anyone an idea how to get NS to create these indexes?
| |
|
| Thanks, Joe... that is exactly what i needed to know.
"Joe Webb" wrote:
> Hi Erick -
>
> Check NSCurrent<EventClass>Events and you'll see your index there.
>
> Rather than directly using the events table, the Generator uses an
> internal table called NSCurrent<EventClass>Events. By using that
> table, the Generator can work with only the events associated with the
> current quantum.
>
> HTH...
>
> --
> Joe Webb
> SQL Server MVP
>
>
> ~~~
> Get up to speed quickly with SQLNS
> http://www.amazon.com/exec/obidos/t...il/-/0972688811
>
> I support PASS, the Professional Association for SQL Server.
> (www.sqlpass.org)
>
>
>
> On Tue, 10 May 2005 12:58:03 -0700, "Erick"
> <Erick@discussions.microsoft.com> wrote:
>
>
>
|
|
|
|
|