ex stored proc and COM objects

Am I right in stating that I cannot create COM objects using ATL inside of
an extended stored procedure? I have need to use an ADODB.Connection object
to communicate with our LDAP. Originally we were just going to use
sp_OACreate in a "regular" stored proc, but since we need to permit
non-admin types to execute the stored proc, that is out of the question. I
figured an ex proc is the only way to go now, but have the COM issue with
which to deal.
Any hints or suggestions?
Tim> Am I right in stating that I cannot create COM objects using ATL
> inside of an extended stored procedure?
Not to my knowledge. Why do think there will be
a problem specifically with ATL? Apartment threading issues?

Event Type for Object:ALTERED, Object:Created , Object:Deleted Event Class

Hi

I am trying to create a EVENT NOTIFICATION for tracking changes to existing database objects. New Database objects, DEletion of any database objects.

For this I would like to know what is the EEVEN TYPE given in CREATE NOTIFICATION syntax for the three events...

CREATE EVENT NOTIFICATION Logging_Schema_Change_Notification

ON DATABASE

FOR Object:Altered_EVENT -- This is the piece that is failing ...what is the name ?

TO SERVICE 'LoggingSchemaService', 'current database'

GO

regards

Imtiaz

Try

FOR Object_Altered

FOR Object_Created

and

FOR Object_Deleted