Reply to Re: Capturing Mysterious Truncation/deletion of a table

Your name:

Reply:


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

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация