I executed the following query....

"select object_definition(object_id) ,*

from sys.triggers

where parent_class=0"

and this is what it says about ddllogger.....

create trigger ddllogger on database for ddl_database_level_events as declare @xmldata xml ...

I fired the following query connected to AdventureWorks.....

Select * from sys.triggers

It displayed 'ddllogger' in the results.

When i fired the same query connected to Master

It returns nothing.

But whats the role of...

yes........AdventureWorks is the database i am working on.

I never got this error ever before....its quite strange.

Regards

ItzSam

Hi

executed sp_Help 'ddllogger'.

It says...."Msg 15009, Level 16, State 1, Procedure sp_help, Line 66

The object 'ddllogger' does not exist in database 'AdventureWorks' or is invalid for this operation."

Regards

ItzSam

i executed sp_Helptext 'ddllogger'......which basically gives the content of stored procedure.

But it says no stored procedure with name ddllogger in the Database.

Regards

ItzSam

Hello Chris

Its the only code i am executing...nothing else on the query window.

No procedure......nothing

Regards

ItzSam

Can we Install SQL Server 2005 Enterprise Edition on Windows XP Professional Service Pack 2?.............I am trying the same but the "Components to Install Page is not highlighted".............Please Help!!!!!!!!!!