Thank you very much and I will look into sizing the database.

I understand. Thanks for the help

Yes, you are correct about the rollback because if i click no the window says Rolled back transactions.

I dont understand how you said to do it in SSMS...

I see and will look closer at it.

Thanks for your help

The following are the two queries that i run after the accounting staff closes the books for the month/period. the queries where written by a DBA to change the check...

I understand how to join tables, but dont know how it would help. Once the tables are joined what then.

Sorry, I am a newbi

Thanks for your reply

So you are saying that i would create an SQL agent job to run on the first of every month and put the query in the job....

Thanks, let me know if you need more information I went through hell with that server for serveral months. Once i thought it was fixed it would happen again....

this is one article

http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1184406

this is a better article

http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1185055

this is the microsoft hotfix that i used.

KB932755

On May 2nd, 2009 I did the following:

•Ran insight diagnostic...

I can send you the article, but it is in my office at work. I will send it to you on Monday if that is ok. Also, I...

You are now making me curious about what is happening. I detached but did not delete the files yet, so I can look into this situation.

I am...

Q: nothing running at all? Even just running reindex on the database will cause log file growth and if you have growth factor at default 10% its going to grow...

Thanks for the help. i wont worry about the Buffer and the Page life, but the transaction log file is kind of weird.

The server is doing nothing....

This issue turn out to be an HP problem with the new Quad core CPU's communicating with the Hard drive controller. I ended having the problem again and then...

Thanks for the help, but I do not have the SMS services on the server.

Let me know if you have any other information.

Thanks for you help