我们可以使用Trigger来阻止User对DB上的某个Table进行Drop/AlterCREATE TRIGGER safety
ON DATABASE
FOR DROP_TABLE, ALTER_TABLE
AS
PRINT 'You must disable Trigger "safety" to drop or alter tables!'
ROLLBACK ; 请问我们能否通过Trigger来阻止对某个Table的Rename
ON DATABASE
FOR DROP_TABLE, ALTER_TABLE
AS
PRINT 'You must disable Trigger "safety" to drop or alter tables!'
ROLLBACK ; 请问我们能否通过Trigger来阻止对某个Table的Rename
for update
as
rollback
for update
as
rollback
create trigger Test_temp_Rename on Test_temp
for update
as
rollback
sp_rename 'Test_temp','Test_temp2'不可以的......