[Top] [All Lists]

Re: Index creation

Subject: Re: Index creation
From: Joe Webb
Date: Wed, 11 May 2005 01:57:55 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
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. 


Joe Webb
SQL Server MVP

Get up to speed quickly with SQLNS 

I support PASS, the Professional Association for SQL Server.

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>