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

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

Accessing Microsoft Analysis Server from Remote Machine

Setup Analysis Server
By deafult Analysis server can only be accessed from the local machine. If you want to access it from a remote machine you will have to firstly expose (enable HTTP access to) the analysis server via IIS. You do this by creating a virtual directory in IIS. The detailed process on how to web enable analysis server is given here:

Enable HTTP access on Windows XP
Enable HTTP access on Windows Server 2003

Make sure that you follow the instructions line by line for your operating system. Mostly instructions are same but on Windows Server 2003 you also need to create Web Service Extension. So make your you follow the instruction correctly.

Testing that analysis server is accessible from remote machine
After complteting the instructions mentioned in the articles above you should be able to access analysis server via a web based URL which will be something like http://machinename/olap/msmdpump.dll

Try the URL in internet explorer, if you get some xml results back then great you have successfully accessed the server from remote machine. If you get a page can not be found error then try accessing the URL from Excel. I have experienced issues accessing URL from IE, but it works fine in Excel.