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 in single-user...

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...

Attached is the output of Select * from sys.transmission_queue.

Thanks,

MJ

Try this:

-- Declare local variables

CREATE TABLE #DB_Space (

DBname varchar(25),Name varchar(100), FileName varchar(100),

Size_in_MB varchar(20),

Space_Used varchar(20),Available_Space varchar(20),RunDate Datetime

)

EXEC master..sp_MSForeachdb '

USE [?]IF DB_ID(''?'')>4

BEGIN

INSERT INTO #DB_Space

SELECT db_name(dbid),sf.name AS [File], sf.filename as...