• what you have described will work. see

    http://msdn.microsoft.com/en-us/library/ms188754(v=SQL.100).aspx

    ---------------------------------------------------------------------