Deleting triggers - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Deleting triggers

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-11-03 : 08:07:24

Paul writes "I had to convert several paradox DB to SQL and in doing so
created several triggers in the SQL DB to easy the input workload

I now want to delete these triggers as they should NOT go out
with the DB, as the program it have to be attached to have this built in..

But I can't find them..... where are they stored ???

A warm thank you for your work on this website...keep it up"

Kristen
Test

22859 Posts

Posted - 2006-11-03 : 08:19:17

In SQL 2000 this should do:


SELECT TOP 100
	P.name, T.name
FROM	dbo.sysobjects AS T
	LEFT OUTER JOIN dbo.sysobjects AS P
		ON P.id = T.parent_obj
WHERE	T.xtype = 'TR'
ORDER BY P.name, T.name

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources