Posted by Hugo Kornelis on 02/15/06 00:24

On 14 Feb 2006 11:22:25 -0800, coolnoff@hotmail.com wrote:

>I have a dts which creates a table which is utilized on my local
>intranet. The DTS runs without error and the table is
>created/populated/transfered to the appropriate db. Then it appears
>that there is an action on this table which truncates it. I have been
>unable to determine the culprit. Can I create a trigger that will
>capture truncation? I have tried to create a trigger to capture this
>information but none that I attempt seem to work on capturing a
>truncation or a drop table and re-create.
>
>Any help would be greatly appreciated.
>
>MT.

Hi MT,

In SQL Server 2000, there is no way to monitor either truncation or
dropping of a table using triggers. You'll have to use Profiler to find
out who/what is destorying your data.

--
Hugo Kornelis, SQL Server MVP

• Next in forum: Re: concatenate two fields in a view?
• Prev in forum: About Join OR Where
• Thread view: Re: Capturing Mysterious Truncation/deletion of a table

[Reply to this message]