• 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]