logging of every transaction
-
Plz suggest me the way so i can track
*who fired any DML,DDL etc on my tables,and other objects,when that fired so that i can track each and every thing happening with my db
so plz suggest the way to preapare a log for all the things happening to my db.
for table level transaction should i go for trigger.
Thanks
-
but it will be taking more memory so performance issue could be at client side ,even if i want to see only the modification on my db ,it will be a difficult job to extract that info from profiler file,is int?
Even i cant give the right to client to start a profiler.
Thanks
-
Although I don't really understand what you want to do, take a look at C2 auditing in BOL. Should give you what you need.
...and a whole lot more of overhead
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Frank ur right to use c2 auditing but what i know is that in c2 auditing we can not instruct sql server to auditing for particular objects ,this facility is with profiler trace but it depends on sql server start and stop so plz suggest any way to deal the situation bcz there is no need to log all the objects ,i want this for only particular objects.
Any way in C2 Auditing or any other way.
-
No, with C2 auditing you get all or nothing. But maybe there are third-party products around.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply