help. Trigger to create log file

Question

Post reply

help. Trigger to create log file

langkhachcodon

SSC Rookie

Points: 40
More actions
July 26, 2010 at 12:19 am

#221651

I want to create log file in my projec.
when user login my program, his imformation will save. Then input log file.
In database have table store this imformation.
I think trigger can use to do this.
who can help me ? thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

sumit.agrawal SSCommitted Points: 1616 More actions · Answer 1

U can create insert trigger on Login table or on the table where u want to log info...

U can store the logged data in tables...

langkhachcodon SSC Rookie Points: 40 More actions · Answer 2

thanks. you can give me example ?

but, a lots table, must i creat all it table ?

:w00t:

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

I think you're going to have to explain in more detail what it is you want to do here.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

bbop1322 SSCommitted Points: 1714 More actions · Answer 4

I found an nice script for creating auditing triggers on thsi very site a long time ago! It is called AutoAudit. But like GilaMonster said you really need to define what the purpose is.

Think great, be great!