Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pras2007
Posting Yak Master
216 Posts |
 Posted - 2010-01-29 : 07:09:15
|
| Hello All,Is it possible to create a table that keeps a log of users activities such as the following: - Creates a table- Delete a table- Update a table- Selects a table- Execute stored procedure- Access a viewWithout creating a trigger?Please advice.Thanks. |
|
|
DaleTurley
Yak Posting Veteran
76 Posts |
Posted - 2010-01-29 : 08:41:04
|
quote:
Originally posted by pras2007
Hello All,Is it possible to create a table that keeps a log of users activities such as the following: - Creates a table- Delete a table- Update a table- Selects a table- Execute stored procedure- Access a viewWithout creating a trigger?Please advice.Thanks.
Try reading through this - see if it fits what you need[url]http://msdn.microsoft.com/en-us/library/aa905160(SQL.80).aspx[/url] |
 |
|
|
|
|
|
How to create an audit function on my database