Date parsed: 31/10/2007 16:03:19
Date: Wed, 31 Oct 2007 23:03:19 -0700

Hi Ant

This SELECT will generate DROP TRIGGER statements, but it will not execute
them to actually drop the triggers. You need to take the output and execute
it.

--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com


"Ant" <Ant@discussions.microsoft.com> wrote in message
news:16961357-9B6B-4878-9E5C-47C532BAF8EA@microsoft.com...
> Hi,
> I'm using:
>
> SELECT 'DROP TRIGGER ' + name FROM SYSOBJECTS WHERE type = 'TR'
>
> I've used this on a number of occaisions but it doesn't seem to be
> dropping
> the triggers this time.
>
> Can anybody think of what I may be doing wrong here?
>
> Many thanks for any assistance in advance
>
> Ant