Monthly Archives: January 2014

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%’

%d bloggers like this: