No I have not tried that statement yet.

The archived data is no longer needed.  Right now we can free up 60G by moving the off to another storage media.

If I do a print, I get the message:

Insert MessagesArchive.dbo.ActivityLog2005June  Select * from ActivityLogView Where SessionID = '{9C49937F-4533-4540-B121-0A776191A54A}'

I can run the statement in the Query Analyzer and it will work. ...

The archive table is extremely large.  By splitting the table into multiple tables, we can backup the previous tables to CD/tape and remove from SQL.