How to list all triggers in the database with sys.triggers in ms sql server?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

what is a self join? : Sql server database administration

0 Answers  


How do you run a trace?

0 Answers  


How To Find That One Week Change in My DataBase we Have Done Like We Have A database Test I Change Table,Stored Procd. Then I Find Which SP,Table We Have Edit/Change in Seven Dayes

1 Answers   INDUS,


Explain different types of self contained sub query?

0 Answers  


how to connect sybase to sql server 2005?.

1 Answers   ABC,






Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?

5 Answers  


What do you understand by the denormalisation?

0 Answers  


How to check if a table is being used in sql server?

0 Answers  


What are the extra roles available in msdb? : sql server security

0 Answers  


What is the difference between for auto and for nested?

0 Answers  


What are the indexes in sql server?

0 Answers  


Can you explain the types of Joins that we can have with Sql Server?

2 Answers  


Categories