I know this doesn't describe exactly the problem that you are facing, however the concepts within this doc might help point you in the right direction

http://technet.microsoft.com/en-us/library/ms176029(SQL.90).aspx