Hi, MS SQL Experts,
Is there a way to create DML(UPDATE) trigger on system view: sys.triggers, or is there any other ways to monitor the column(is_disabled) change on this view?
(I am using MS SQL 2005)
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below:
PERCENT_RANK() function will returns the percentage value of rank of the values among its group.
PERCENT_RANK() function value always in be…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.