dakshinamurthy-655138 (4/19/2010)
Here i am trying to log the changes done for Database Objects from which system and which login the changes have been made.
For this you can only use triggers and fetch the user name with select suser_sname() but for this; user needs to be connect with windows authentication. and for schema changes DDL trigger can help you.
For both windows authentication is must
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)