Thanks Dinesh!
There is just one thing I like to add.
All of these procedures are undocumented and subject to change anytime at Microsoft's will. I would really carefully think about this BEFORE writing production code with these procedures.
Nonetheless I agree it's good to know that there is a way, but then again there are also many other ways. I would prefer doing this in the application layer.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]