Thanks much for the guidance This is really helpfull

I will explore more in this .

Thanks

Thanks .

Could you please help me with server side trace,Can we run the trace 24x7? Any sample will be helpfull

Thanks for your reply.

Trigger - yes it's working solution But the company doen't wanted to use the trigger

SQL Profiler - unable to trace it in a table - Getting error...

Could any one please help.thanks in advance.

we are fine to log into a flat file

but I am unable to capture the required informations like " Hostname" ,"local ip" and "Application Name" ect.

this is for a enterprise...

Thanks Very Much this is really usefull.

Appriciate your help.

is there is anyway we can get the same output using the SQL Audit

please help,

When i try it with the SQL profile using the table

getting the below error not sure why?

Failed to Save table <tablename>

cursor operation conflict

Yes, i tried with SQL Profiler to record the event.but Unable to login into a table

getting error " Failed to start the new trace" But I was able to trace...

Logon trigger - In case any issue with the trigger this will not allow any users to login into the DB.

outpout in table is more preferable.

Could you please help me with how to setup the audit

I am also looking for the same level of audit information

Client IP

Client Host Name

Server IP

Server Host Name

DB...