Prev: The query processor ran out of stack space during query optimization. Please simplify the query.
Next: SSIS:Date converting error
From: WhytheQ on 11 Nov 2008 07:33
Hello,

(my first post to this group so please expect some vagueness!!)

I'd like to be able to find out who created certain tables - if it was
me then I know I can delete the table.
We are using SQL Server 2005.

Can't see anything in the table properties - wondering if this info is
stored somewhere?

Any help much appreciated

Jason
From: Aaron Bertrand [SQL Server MVP] on 11 Nov 2008 08:00
No, SQL Server does not track this information. You can track it yourself
going forward, using a DDL trigger...


"WhytheQ" <WhytheQ(a)gmail.com> wrote in message
news:81e2779b-d63f-48cd-9f50-2ad88d9b9fc3(a)a3g2000prm.googlegroups.com...
> Hello,
>
> (my first post to this group so please expect some vagueness!!)
>
> I'd like to be able to find out who created certain tables - if it was
> me then I know I can delete the table.
> We are using SQL Server 2005.
>
> Can't see anything in the table properties - wondering if this info is
> stored somewhere?
>
> Any help much appreciated
>
> Jason


From: Alex Kuznetsov on 11 Nov 2008 09:38
On Nov 11, 6:33 am, WhytheQ <Whyt...(a)gmail.com> wrote:
> Hello,
>
> (my first post to this group so please expect some vagueness!!)
>
> I'd like to be able to find out who created certain tables - if it was
> me then I know I can delete the table.
> We are using SQL Server 2005.
>
> Can't see anything in the table properties - wondering if this info is
> stored somewhere?
>
> Any help much appreciated
>
> Jason

The best practice is to use only deployment scripts checked into
source control to create/alter/drop objects, and to have rollback
scripts for every deployment too. Once you adhere to this policy, you
can simply search thru your deployment scripts.
 | 
Pages: 1
Prev: The query processor ran out of stack space during query optimization. Please simplify the query.
Next: SSIS:Date converting error