Thank you so much for the help. 

I've just confirmed that I'm running Win 2k Server Standard and my Page Life Expectancy is around 170. So I've definitely got some memory...

Windows 2000 Server (Not advanced)  Task Manager shows it using 4 processors and 4 GB RAM (with 1.6GB available right now)

I'm having a hard time checking anything in Perfmon because...

I did a quick test in my sandbox db and created an account to become the DBO "NewDBO".  Then I created a datareader-only account tied to window's auth and sp_changedbowner 'NewDBO'.  The NewDatareader account couldn't...

I'm not great with Windows Auth since most installations I've worked on actually were SQL Auth only, but I'm having to work under Windows Auth now myself and was thinking...

If I'm understanding you correctly you can just use File->Open or just drag and drop the file onto an open QA instance.  However, QA needs to be connected to a...

i am running enterprise edition with quad processors and 4 GB RAM. The Dynamic settings are set to max at 3008MB which I can probably increase a bit since this...

Found the KB article reference (http://support.microsoft.com/kb/271624/en-us) in another thread.  Don't fully understand it yet, still reading.

4GB I know it does.  I haven't gone farther myself.

DBCC FREEPROCCACHE didn't help.  As much as I'd like to, I can't restart SQL Server on Production without more justification. 

We are on SP4 for both SQL Server and Win2K Server

DBCC...