NLog Logging library

NLog is a nice and free logging tool. NLog library that allows .NET applications to log output to a variety of sources. It makes it easy to produce and manage high-quality logs for your application regardless of its size or complexity.

NLog support following mode to store the information

• File
• Console
• Email message
• Database
• Another machine on the network (using TCP/UDP)
• MSMQ-based message queue
• Event Log

Search text in SP and Function

SELECT SOBJ.NAME, SYSC.TEXT
FROM SYS.SYSOBJECTS SOBJ
JOIN SYS.SYSCOMMENTS SYSC ON SOBJ.ID = SYSC.ID
WHERE SYSC.TEXT LIKE ‘%Text to search%’