You CAN drop indexes anytime. But if you are planning on creating or re-building those indexes maybe you want to do during an off time period depending on your traffic.

I think he is trying to ask how would he know if he needs an index.

Answer being, analyze the execution plan, it is your most effective way for determining whether...

Also make sure you are using Outlook 2000 and not 2002, 2003, or XP. The newer versions don't create a MAPI profile that can be started without an interactive login. ...

You are half-way there. If you have created a MAPI profile with pop/smtp, then you will be able to use with xp_sendmail. Did you reboot afterwards? Probably not, using pop/smtp...

Apply the optional patch available via Windows Updates, then do nothing.

Just an opinion.

Syncing will not work because the time that is sent by the time servers is not an absolute time, it is a referance time. If you have a...

To send emails you do need to have SMTP server somewhere on your network. Then you can use vbscripts using CDO to send email alerts.

To start, I have not used PSFTP..But here are my steps for troubleshooting.

Start by adding @ECHO OFF to the top of the batch script so you do not see everything...

I think a clarification in the situation, and question is needed before people start answering questions that were not asked.

I read the post and interprit as such . There is...

Using the SET command should take care of what you are trying to do.

You probably want to do something like SET PATH=%PATH%;Additional Path.

Just a simple reply to the statement regarding what about TEMPDB transaction logs in ramdisk and crash. Don't forget TEMPDB is recreated everytime you boot up your machine, which is why most...

Possible overactive Firewall/IDS blocking zip files?

Set FTP to binary? (Actually this should only cause corruption if set to ASCII, not prevent download, but throwing it out there.)

Have you manually(FTP on...

I think the error message said it all. And is not actually an error. Some services like SQLagent, Performance Counters and logging actually stop if there are not jobs, or...

You should first be aware of the method you are using to determine that "it is not using more than 2gb." Using task manager will not give you an accurate...

The newer Windows PPCs are very capable of VPN connections. You may consider setting up a VPN server at home. I Linksys router with OpenVPN installed is a nice option....