Full text details using TSQL

-- catalogue details
SELECT name, path, is_default, is_accent_sensitivity_on
FROM sys.fulltext_catalogs

-- full text index details
SELECT object_name(object_id) table_name, change_tracking_state_desc
FROM sys.fulltext_indexes

-- full text index columns details
SELECT distinct ixc.object_id, object_name(ixc.object_id) tblname, col.name, ixc.*
FROM sys.fulltext_index_columns as ixc
INNER JOIN sys.columns as col ON ixc.object_id = col.object_id AND ixc.column_id = col.column_id
ORDER BY col.name

SQLDBTools - Tools

SQL Server 2005 database schema comparison

At last my search to find a good quality free database comparison tool is now over.

Worth a try: SQLDBTools - Tools

SQL Server 2005 Database comparision

SQLDBDiff V1.2.0 (Freeware)
http://www.sqldbtools.com/Downloads.aspx?ProductId=1

Best free database comparison tool.

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

TSQL IsNumeric not working correctly

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

DataContext object serialization: Circular reference issue

I found following article very useful: http://www.west-wind.com/Weblog/posts/147218.aspx

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...