Hey guys, I've been looking for a script like this so thank you very much.

I was curious...can this script run on sql 2000?

Thanks Patti

Thanks Paul. I'm with ya on the memory thing. Have a good day and thanks.

When you say administrator on the server, do you mean member of local admin group? I know it's been a long time ago so thanks for replying.

Did you ever get an answer to this? I have the same problem. Thanks. Patti

Thanks Guys. I read that 64bit AWE was already set regardless of the AWE setting but when I saw the first server configured like that I was thrown off....

Thanks ALZDBA. The solutions that I think you provided are for a one time solution. I could be mistaken.

What I want to do is automate this to...

Hey it doesn't have to be a script. I'm happy with a process or procedure that works and is automated.

Help! 😀

Guess what guys....???

I am retarded and embarassed at the same time! 🙂 I didn't realize that my backup file didn't have the extension of BAK. I didn't notice...

What I did was go all the way until it was time to select the file. It doesn't display the file, so I went to the OS and copied...

Thank you very much for responding.

I had posted on the SQL 2000 forum a question regarding memory configuration with 2 instances of sql 2000 in a server. No one...

Hey Muthukkumaran,

Your website link said to defrag indexes based on these conditions:

1. Fragmentation >30 AND PAGES>1000 then rebuild

2. Fragmentation between 15 to 30 AND PAGES>1000 then reorganize&updatestatistics

3. If the...

Thanks Gail. I was looking at that class and you are right! Wow! That's my type of class. I would love to attend "all" of them not...

Gail, isn't there a % that you can use that is "sort of" a best for almost all? I have over 250 databases or more and it would be...

Hey Jeffrey Williams and all,

I think you have all made good points and have shown me areas that I need to fix in my weekly maintenance plans.

I...

Thank you both very much. I like those scripts and plan to incorporate them into my sites.