CLSID_SQLSERVERCE_3_5 = {0xF49C559D, 0xE9E5, 0x467C, {0x8C, 0x18, 0x33, 0x26, 0xAA, 0xE4, 0xEB, 0xCC}};

If anyone's interested, we offer a free native-code IDE for SQL Server Compact. Details at our web...

You can look in msdb..restorehistory, which links to msdb..backupset, which in turn links to msdb..backupmediafamily.

I think what Sergiv meant was that all the time was spent transmitting the data from the database to the database client, in your case its Query Analyzer. Probably...

If you run SET STATISTICS TIME ON prior to running the stored procedure, do the time breakdowns indicate anything useful?

If it runs at predictable times, you could try running sp_who2 when its running, and try to identify the connection using the CPUTime, DiskIO and LastBatch values as markers. ...