Wednesday, 21 October 2009

Searching stored procedure code

Many times I need to search stored procedure for certain text. I find following code helpful:

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

Monday, 17 August 2009

TSQL IsNumeric not working correctly

See following for details:
http://classicasp.aspfaq.com/general/what-is-wrong-with-isnumeric.html

Sunday, 28 June 2009

SongBird - Open Source Music Player

Website: http://getsongbird.com/

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

I was looking for a free and easy way to document Sql Server schema. I found t-sql script provided in following article very useful:

Article: http://www.codeproject.com/KB/database/SQL_DB_DOCUMENTATION.aspx