microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Index creation

Subject: Re: Index creation
From: "Erick"
Date: Wed, 11 May 2005 07:36:05 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
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/tg/detail/-/0972688811 
> 
> I support PASS, the Professional Association for SQL Server.
> (www.sqlpass.org)
> 
> 
> 
> On Tue, 10 May 2005 12:58:03 -0700, "Erick"
> <[email protected]> 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?
> 
> 

<Prev in Thread] Current Thread [Next in Thread>