• Thanks for your reply it worked on sql server 2008, but

    on sql server 2005 it is giving me following error

    Msg 195, Level 15, State 10, Line 4

    'CONNECTIONPROPERTY' is not a recognized built-in function name.