Can't you just run on the 1st day of the month at 12 am?

This is how i have done as a solution of this problem .

In my company, there won't...

Thank you. Your explanation is really good. I understand it. I really appreciate your help.

Thanks Gail and Jeff,

I have one more question now...

So do i have to apply those indexes in test and find out if performance has improved or not by running...

Thanks Everyone. I appreciate your answer.

Jeff ,

Yes, you are right. I ran so many scripts from this website in our test server and our system was extremly slow.

I did not...

Skcadavre,

Thanks for your reply

Thanks Lowell.

Floor worked for me.

SELECT SALESTABLE.salesid,SALESTABLE.MODIFIEDTIME, SALESTABLE.MODIFIEDTIME/60/60 as hour,

((CAST(SALESTABLE.MODIFIEDTIME AS float)/3600) -floor((CAST(SALESTABLE.MODIFIEDTIME AS float)/3600)))*60

FROM SALESTABLE

where (SALESTABLE.SALESID = N'SO1000863')

Result

salesidMODIFIEDTIMEhourminute

SO1000863389021048.3666666666667

It's so funny .......i thought grasshopper is a name.

Sorry izdede.

Thanks.

GilaMonster,

Thanks for your valuable information.

Thanks for your suggestions. Okay then for now i will upgrade them to 2008.

Hi Grasshopper,

Thanks for your help.

This is infact very useful, becasue it even gives me text.

I tested it and it still shows the user name we have stored securely in...

Thanks Mister Magoo.

No it's not like that, i was just enjoying my July 4th weekend, so did not bother about activity monitor and this forum. :blink:

ExecutionLog table gives you...

Seems like noone is willing to help me :crying:

Thanks Paul.

Yes,i have already installed sql server 2008.

Is your Understanding Database Administration book based on 2005/ 2008 ?

Grasshopper ,

Thanks. I already downloaded the book.

Steve , Thanks for the...

Thank you very much. I will read it soon....