Droping Triggers For Sys.server_triggers

Question

hi i create one trigger at database lavel to stop creating database

but now i want to disable trigger

but it's showing following error

Cannot find the object "R_Tr_Database" because it does not exist or you do not have permissions.

how to enable and disable or drop this trigger witch is store  in sys.server.triggers 

Answer 1

I would have to think such triggers would be defined at server level...do you see any triggers under--> server objects--> Triggers in your object explorer.. right clickon the trigger and see if you can disable them....

---

Hope it Helps!!

Answer 2

Make sure you have write privilege on the relevant object and read

http://msdn.microsoft.com/en-us/library/ms189748.aspx

---

Many Thanks & Best Regards, Hua Min

Answer 3

first can you check the trigger existence. where its lying currently..?

Answer 4

ya i got it in server objects but on right click it's not  showing any  option like enabling and disabling triggers 

Answer 5

i am using sa account so it will have all rights na 

Answer 6

i am using sa account so it will have all rights na 

What have you executed to get this error?
Cannot find the object "R_Tr_Database" because it does not exist or you do not have permissions

---

Many Thanks & Best Regards, Hua Min

Answer 7

ok i got it i just Wrote database instead of all server 

what happen  earlier i wrote this Following  query to enable and disable that triggers 

   

disable trigger R_Tr_Database on database

then i wrote this following query  and it's works 

 enable trigger R_Tr_Database on all server 

Thanks