quote:
You can use the ALTER TABLE command to disable and enable triggers. Also you can use sp_trigger created by Rodrigo G. Acosta. Its in the SQLServerCentral scripts area at: http://www.sqlservercentral.com/scripts/contributions/484.asp
thanks ,but I want to restrict other DBA from performing Dropp triggers against the table.any idea like this article is needed.