Server has not been re-rebooted or SQLserver re-started and tempdb settings are good.

I am sysadmin and can certainly change the dboptions.  I also checked afterwards to make sure they were changed.  I also doubt that this financial app changed it, but then...

2GB Memory, Compaq ProLiant DL580 G2, 2X1396 mHZ

Mem dynamicly configured with MAX 1946

active/active cluster

Full Text search installed and started, but not used.

Version:

Microsoft SQL Server 2000 - 8.00.760 (Intel...

Frank

The backupsize and the 'reserved' space in sp_spaceused is the actual space currently used (where datapages are written on)  -  the rest is just reserved and is really empty space and...

Thanks Bert!  The collumn name has been changed.

If it is an existing database, you can get history about data file and actual data growth from backup history.  See http://www.sqlservercentral.com/scripts/contributions/901.asp

Thanks, but I need a way to check this without generating an error. I have a job step which sends mail and I do not want the step to...

I do not want to stop mail if it is running!

Thanks Jonathan. I also came to the conclusion that changing the threshold or maxdop are the only options. But now I have more questions on parallelism and thought...

I think you should try and solve the xp_logininfo issue first. It looks like xp_sendmail is trying to validate the username who is executing the query. My problems...

I've done some more testing and discovered that the problem is definitely with SMP. I added option maxdop 1 after the where clause and the query was much faster!!...

quote:

---

quote:

---

Do you get valid results for xp_logininfo 'DDDD\blah' ?

---