who changed my table ?

#1

....is there an easy way to see this in the database or do I need to
set up some kind of auditing mechanism ?

#2

On Thu, 20 Oct 2011 00:13:01 -0700 (PDT), Dog is love
<michaelnewportyahoo.com (AT) gmail (DOT) com> wrote:

Quote:

...is there an easy way to see this in the database or do I need to
set up some kind of auditing mechanism ?

You'll need to set up auditing.
--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

#3

On 20 Okt., 10:02, Hugo Kornelis
<h... (AT) perFact (DOT) REMOVETHIS.info.INVALID> wrote:

Quote:

On Thu, 20 Oct 2011 00:13:01 -0700 (PDT), Dog is love

michaelnewportyahoo.... (AT) gmail (DOT) com> wrote:
...is there an easy way to see this in the database or do I need to
set up some kind of auditing mechanism ?

You'll need to set up auditing.
--
Hugo Kornelis, SQL Server MVP
My SQL Server blog:http://sqlblog.com/blogs/hugo_kornelis

thanks

#4

Dog is love (michaelnewportyahoo.com (AT) gmail (DOT) com) writes:

Quote:

....is there an easy way to see this in the database or do I need to
set up some kind of auditing mechanism ?

There is nothing built in. The auditing mechanism that comes closest at
hand in this case is a DDL trigger.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

who changed my table ?

microsoft.public.sqlserver.server microsoft.public.sqlserver.server

who changed my table ? - 10-20-2011 , 02:13 AM

Re: who changed my table ? - 10-20-2011 , 03:02 AM

Re: who changed my table ? - 10-20-2011 , 06:53 AM

Re: who changed my table ? - 10-20-2011 , 04:21 PM