it does not seem to be systax error because it worked on DATABASE but not working ON SERVER

I am getting the following error when creating FOR ALL SERVER

Msg 1098, Level 15, State 1, Procedure [TR_DB_NO_DROPPING_OBJECTS] , Line 58

The specified event type(s) is/are not valid on the specified...

great thank a lot Lowell.

finally can i use triiger for prohibintg INSERT,UPDATE and DELETE also ?

I am sorry if i have confused you.

from the above script does it mean that users listed in NOT IN cluse can drop the tables.

Actually my goal is to prohibit...

Looks like this trigger prohibits dropping all tables and all users and it is raising error only for the given users.

I want to prohibit everyone except User1 and User2 only...

actually i want to handle this in reverse like say i want to restrict access to eevry one except one win group, how do i filter that group or is...

Lowell

This looks exciting to me and would like to try but few questions..

1. Yes i have 3 tables only across all servers

2. i have 2 win groups to restrict this...

Is it possible to create a trigger that will DENY few users to drop/insert/update/alter only on few tables across the server?

I have TableA,TableB,TableC on all databases in the server for...

That is how the system is setup which can not be changed as they need liberty to drop and create tables other wise i will have to do that for...

Is there a way to restrict ddl_admin role members for insert,update,delete and drop on some tables but they still have to be ddl_admin on the whole database. I want to...

These users have R/W/ddl_admin previalges on the dataabase and so i am trying to deny those permission.

Is there a way i can restrict these users for dropping at table level...

I understand this trigger fires on the whole server but do i need to create this on master database so that i can restrict people from dropping/updating the tables i...

tables are fixed but will be created after the database is created.

If i have to execute this through a trigger how do i fire it across all databases when these...

how does the trigger keep track of any new database?

The SP i created will deny permission for some users on few tables to drop or update them. I would like this to be executed as and when new database...