But this Hostname is throwing only the server Name. Not the Machine name of User.

STRANGE :S

Here is the script i edited fo this.

Create trigger backup_objects

on database

for create_procedure, alter_procedure, drop_procedure,

create_table, alter_table, drop_table,

create_function, alter_function, drop_function

as

set nocount on

declare @data xml

set @data = EVENTDATA()

insert into...

See the error.

Let me clear you the scenario:-

One Login

Mutilpe Users.

Off course in this case only single Username would be output. But the purpose is to track the related client machines.

I hope you...

After executing this trigger on the server.

I am unable to add any database unless i run:-

drop trigger databaseCreated on all server

WHY?

Thanks

What is meant by "profile'

@profile_name = 'profile',

Secondry ; Did i need to run this script everytime whenever i need to know or run once?

I just want to set SQL...

Really Appreciated.

Redgate is Not freeware 🙁

Any Freeware Solution for this scenario? Monitoring tool?

I couldn;t understand your point. Pls elaborate a bit.

Thanks in advance.

There is also an option that you can select in SSMS to include this if you are auto-generating the scripts

How? Pls share.

Thanks for your motivated replies.

Can you share a sample Template or Guideline with me.

Thank you all for your wonderful replies.

"RedGate Software" is Liscenced.

Any open Source TOOL?