DEFINITIONS

Definitions More Info.
Definition ID307
TitleSQL
CategorySCRIPT
DefinitionCreate server trigger template
Definition Description--==================================== -- Create server trigger template --==================================== IF EXISTS( SELECT * FROM sys.server_triggers WHERE name = N'' AND parent_class_desc = N'SERVER' ) DROP TRIGGER ON ALL SERVER GO CREATE TRIGGER DBA_CHECKER ON ALL SERVER FOR AS IF IS_MEMBER ('db_owner') = 0 BEGIN PRINT 'You must ask your DBA to drop or alter databases!' ROLLBACK TRANSACTION END GO
RecordBycunay
Record Date07-02-2013 13:28:29
Düzenle
Kopyala
Sil