Archive

Archive for January, 2014

NLog Logging library

January 28, 2014 Leave a comment

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
Advertisements
Categories: NLog

Search text in SP and Function

January 7, 2014 Leave a comment

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

Categories: SQL
%d bloggers like this: