Jeffrey Williams-493691 (8/30/2010)

---

Why are you shrinking databases? This should not be an automated process, or something that is done on a regular basis - even if not automated.

Databases will...

I just ran the job at a step and working fine now.

Thanks for your help

chetanr.jain (8/30/2010)

---

Kindly provide more information.

1) What is this procedure (GetFileSpaceStats) will return.

2) WHen u r using xp_fixeddrives, why r u using GetFileSpace Stats

3) Try to connect to SSMS and...

GilaMonster (8/25/2010)

---

What happens to indexes that are...

jerry-621596 (8/25/2010)

---

We have many procs that need to run in multiple databases. What we do is use MultiScript to push those out to the databases.

The procs are then run...

Its working fine now.

Thanks for your help

No there is no other step.

I just took out the script and ran on server, its working fine .

I really dont understand what the exact problem is.....

I have attach the document in excel file with desciption.

I hope that would be k this time.

Thanks a lot

Hi jacob

Thanks for your reply.

It doesn't mean that i dont want job. But we have to delete that records everyday.

And that deletion must be stop at 6:00.

The job will start...

Is there any way to do without Scheduling job?

Like using date function.....

What if i would like to without scheduling job?

Is there any way i can do that? like using Date function...

Thanks all for your reply.

But i do have quick question, how can i start at 12:00 everynight and finish at 6:00 AM with some delay so it wont overwhelm application

Query takes only 4-5 second but we have a requirment that logical read should be <=5000.

Can we use temporary table to tune the query?

I have tried creating two temporary table...