Create a trace and run it during the time you need to find out.

capture SQL depepnding upon the duration from the trace and run into SQL Analyser for execution plan.

When you take Log backup the unwritten transactions are written to the disk and your log file will reduce after the backup completes so you may experience the large log...

If you need to gather specific information of user over specific time best option would be create and run a trace.otherewise you could follow the previous post.

Windows XP wont allow to install SQL Server Ent edition

In activity monitor you have a cloumn status which would says runnable this means the user is active at present and doing some action.

There are two SP map_login and sp_sidmap which can be downloaded form microsoft website.

Try droping and recreating indexes.

You can work in 2005 management studio >Management>Activity Monitor and in 2000 Management>current activity >Processinfo.

also you can use sp_who

After executing Exec XP_MSver you will get 20 rows in result

Checkbelow X86 that means it is 32 bit or if it show X64 then it is 64 bit.

PlatformNT INTEL...

SET quer time out value higher than default.

Check whether you have selected Local and remote connections, or Local connections only in surface area configuration

Try Restart the services.

This will help you.

http://www.sqlservercentral.com/Forums/Topic10251-106-1.aspx

The error message occurred due to incomplete sequence of log backups.there may be some log backups that had generated after you took the full backup.Please check the backuphistory system table...

If you add one more file log shipping wil be uneffected.