Right, the service account is actually holding that permission on the server right now, but I have this odd feeling that it might be overridden at the domain level, as...

Thank you - that's helpful (and it explains the difference between the two machine's memory reporting in the task manager). I had checked on the "lock pages in memory"...

It seems like maybe you have a "lost write" - toward the end of the article it shows your error and gives a small explanation of what happened:

http://support.microsoft.com/kb/826433

Having said that,...

Since no-one else is answering, I'll take a stab - try running dbcc checkdb (or dbcc checktable with ALL_ERRORMSGS, if you know the specific table that it's complaining about) ...

Lock pages in memory is needed if you have AWE enabled (if I remember correctly). http://technet.microsoft.com/en-us/library/ms179301.aspx - these people recommend to enable lock pages in 64-bit.

Their conceptual explanation of...

Just a few random thoughts on the subject - I've got alerts for all of the critical severity levels (just 20-25 right now) going to email, as far as generic...

Heh, a Gulf Coast City would be a step up for me (West Palm Beach, Florida), not that I really want to move.

Weirdest issues I had stemmed from me...

If it's migrated the DTS packages to SSIS packages, you can schedule these to be run by a SQL Server job.

Here's a nice overview to upgrading DTS to SSIS: http://www.sqlservercentral.com/columnists/bknight/upgradingsqlserver2000dtspackagestossis.asp

I believe DTS/SSIS has a login transfer task - http://technet.microsoft.com/en-us/library/ms137870.aspx

I've always found this makes general troubleshooting easier (and I've run into a few situations in which I think it was necessary, I'm trying to recall specifics)

In general, being able...

No, it will not actually run the inserts, it just goes through the objects referenced and "walks through" the steps, your actions from the trace will not be recreated.

I did find an interesting note in BOL about "dropping and rebuilding large objects" which begs the question: was your operation complete when you ran the "current" sp_spaceused? I...

Maybe query the sys.sysprocesses view?

Looks like someone might have built a solution to what you're asking at: http://www.tek-tips.com/viewthread.cfm?qid=1328109&page=2

Normally I would suggest that you put the original table back with the original schema definition of the varchar(13) column, but maybe that isn't the case here. 

My most common...

That did it - for some reason I looked at BOL's command options and all I saw were the ones that defaulted the delimiters to spaces. Thank you thank...