Browse by Tags

All Tags » server   (RSS)
Performace overhead and resolution when using CLR vs TSQL
31 July 07 01:42 AM | SQL Master | 2 Comments   
Integration with .NET framework CLR within SQL Server gives extra flexibility for the developers to use other programming languages such as C# or VB.net by creating functions, stored procedures, triggers, data types, and aggregates are among the kinds Read More...
How do I view the definition of a server-level trigger?
16 July 07 05:43 AM | SQL Master | 0 Comments   
SELECT definition FROM sys.server_sql_modules; GO Books online documented the usage of triggers for the business needs: Creates a DML, DDL, or logon trigger. A trigger is a special kind of stored procedure that automatically executes when an event occurs Read More...
Filed under: , , ,