Hi tyang,
quote:
Again since my boss does not want to spend much money on the third party tools, I will try it on my own, but there are too many tables, so it is hard to set the triger on every table.
maybe you should tell your boss, to consider the implicit cost when things go wrong. These could easily outweight the money he thinks to save right now.
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]