select name, charindex('text to search',object_definition(object_id)), object_definition(object_id)
from sys.procedures where charindex('text to search',object_definition(object_id)) > 0
Wednesday, 21 October 2009
Searching stored procedure code
Monday, 17 August 2009
TSQL IsNumeric not working correctly
http://classicasp.aspfaq.com/general/what-is-wrong-with-isnumeric.html
Friday, 17 July 2009
DataContext object serialization: Circular reference issue
Sunday, 28 June 2009
SongBird - Open Source Music Player
The Open Music Player
Songbird is an open-source customizable music player that's under active development.
We're working on creating a non-proprietary, cross platform, extensible tool that will help enable new ways to playback, manage, and discover music. There are lots of ways to contribute your time to the project. We'd love your help!
There are several features we're proud of, but we'll be the first to admit that others need ironing out, are experimental, or are just plain missing. There's still a lot to do.
Note: I copied above description from SongBird website.
I use VLC Player for videos and music. VLC Player is very good as a video player, but is a very basic music player. Therefore, I started looking for an open source music player and found SongBird. I am going to give it a go and see if it works for me...
Friday, 8 May 2009
Documenting SQL Server database schema
Article: http://www.codeproject.com/KB/database/SQL_DB_DOCUMENTATION.aspx