Processor license will be too much for us I think.   We only have about 150 employees total and all of our APPS are 'presented' to the users via a Citrix...

Thanks again.  I would definitely test the service pack first..  and I am running SQL Server Standard so the AWE memory stuff wouldn't apply.

Thank you so much Brian!!!!!!!!!!! 

We are on a W2K Server with SQL Server 2000 standard patched up to 3a.

Would you recommend patching up to sp4 or should I...

When I run Perfmon, I choose SQL Server and Active Transactions and add

_TOTAL to the instances to monitor, it shows active xactions at

4294967295.  It also shows master DB red-lining,...

Thanks!   I{'m not worried about blowing away the DBs or logins - I just didn't want to create a mess doing things in the wrong order since I will be...

tanks!!

Thank you!!!  That makes alot of sense.

I'll change the 'grow by' from 10% to a static number.. 

like 50 MB.   I'm assuming I can do this at anytime..  don't have...

THanks!   My TEMPDB DB is already in Simple recovery Mode.

The data file for TempDB is 23mb and there is over 50GB free on that drive.

The Log file for TempDB is...

Thank you.  I did go into the Server Properties a couple of time through EM and then X'd out. maybe that caused the errors... 

I seem to get them periodically...

Thanks!! I searched MS but didn't find this.  thanks Brian!

Thank you for your thoughts!   I think I'll skip restoring Master and see how that works.  I'll restore the logins (from a script restoreing the same password and SID) and...

yes, I'm going in through EM to stop and restart the instance in single user mode. I wasn't sure how to start SQL Server from the command prompt being that...

Rudy,

Thanks much.  I tested here on a SQL Server Personal Edition that I have running - Changed Model and msdb to an NT id SID and then back to...

Thank you for the excellent suggestion. if the act of detaching and reattaching Model and MSDB will actually reassign the SID and show 'sa' as the owner again, then I'll...

I suppose it's possible that someone's NT login was the owner and it was deleted.  I have always been able to run sp_helpdb with no problems and I have some...