The procs are created as part of replication - if you're replicating data then most likely you're using them, if you're not using replication then you are not. Make sure...

It'll rollback whatever it's currently doing. Always test, Always test, Always test !!!

you should also be able to use the /PAE or the /3gb switch to get to 3gb used ram. However, the two switches do different things so be careful.

Note...

I think you should have a read up on clustering !! Clusters use shared disks ( in your scenario  a SAN )  you really don't want to put tempdb on...

I'd suggest a read through articles/books by Kalen Delaney or Kimberley Tripp. There's also some whitepapers in technet which cover this. Most secondary indexes are unlikely to have more than...

did you not consider trying an alternative password?

You seem to have answered your own question ?? Use xp_sendmail with a mapi mail client or find a smtp mail proc . link to the results from your query...

there's actually a different approach if your app is all sp driven and you just want to know which procs access your table - do a search in syscomments.

use windows authentication. Open QA from EM against a registerd server.

It probably wouldn't hurt to re-run the sp. It's certainly a step I would take.

Litespeed is awesome if you have large databases. It does exactly what it claims to do and if you use dba procs to handle your backups ( not maint plans...

you should not make this change by updating the system table, that's why it's not working! Use the provided stored procedure sp_update_job.

There is one downside of mail errors on failure...

I don't use maint plans for lots of reasons - however - some basic checks. Jobs run under agent service so the account the agent runs as should ideally be...

I've not typically seen any problems using awe, used it on boxes with up to 32gb of ram. Have had a few problems with the 3gb switch. I'd suggest you...

sorry - noticed you mentioned using maxdop 1 - this would make both queries run the same , yes ?  as there would be no parallelism in either case.

Are we...