• OpenQuery is a good way to go as well but this requires that this method is opened up to more than just the sysadmin role, something that we may not want to do for all users. Also you have to make sure that the OLEDB provider being used has OPENQuery enabled for non admin roles.

    Steve
    http://stevefibich.net
    http://utilitydb.codeplex.com/