It is returning only one row for that person.addresstype table that too for clustered index. It is not returning any information about other two non-clustered indexes on it(previously it was...

Go to Database user-->Right Click-->Properties-->Left side(Click on Securables)-->Click Add..All Objects of the type-->Under Select the types of objects to find(choose Views Click OK)-->Select your sys.sysobjects and ... And in down...

Go thru stored procedure posted at:

http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.html

SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization .

MJ

When I modified one index and included one more column in it under person.addresstype table your SP returned only one row

EXEC [IndexInfo] 'adventureworks'

See attached.

MJ

Sue,

Please put server in single user mode and use DAC to update the system tables in 2005 as mentioned by someone here:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=89594&SiteID=1

The server also has to be started...

Thanks a lot for all your help and brilliant patience. Impressed me a lot.

Actually my problem got resolved the moment I used as per your suggestion:

Create EVENT NOTIFICATION NotifyALTER_T1

ON DATABASE

FOR...

Please find attached output of : Select * from dbo.NotifyQueue

Thanks for all your help.

MJ

Thanks for your time and efforts.

Please find attached output of the three statments.

MJ

I dropped the old one and executed the below mentioned statements in sequence on logging_demo database:

Create EVENT NOTIFICATION NotifyALTER_T1

ON DATABASE

FOR ALTER_TABLE

TO SERVICE 'NotifyService','current database';

alter table test1

add drgs112 int

Go

select * from...

Okie, I dropped that notification and created new one as per your suggestion:

Create EVENT NOTIFICATION NotifyALTER_T1

ON DATABASE

FOR ALTER_TABLE

TO SERVICE 'NotifyService',

'Logging_Demo';

Still no luck after running:

alter table test1

add...

Yep, I am executing alter table command under logging_demo database.

On your suggestion i executed below mentioned commands, still no luck.

DROP EVENT NOTIFICATION Notify_ALTER_T1

ON DATABASE

go

CREATE EVENT NOTIFICATION NotifyALTER_T1

ON DATABASE

FOR ALTER_TABLE

TO SERVICE...

Please find the results attached.

Thanks a lot,

MJ

Hi,

Please find all attached.

Thanks again for your replies and time.

MJ

I executed your sentences and its still not tracking any Alter table events.

Please help. No rows in Select * from 'LoggingQueue' output.

MJ

Forgot to tell you sorry, I changed the logon event to alter table as I was not able to capture server logon events.

Still when I change the schema of...