If you are on SP3 there was a hot fix for it only using 1/2 the memory. Also, SQL is only going to use the memory it needs. ...

That's what I am trying to confirm. So if I have instance1 and instance 2 on the active node, and that node dies, the passive node will pick up...

Not on different server all on same bxo

OK now, synonym is not the issue. I have a windows\sql account that has sysamdin rights.

I have a procedure in database A that the executing user has...

I should have clarified this was during the Virtual Server Configuration setup that I need to respond

Everything will be staying in the same place, db's log files etc. If we can restore master and msdb I am in great shape

THanks, interesting now I am being told they can trap and to use a rule. Since the rule should allow for the first 2 char of being either A-Z...

Is there a way to get past this error, or should I assume everything else is OK.

Nothing in scheduler, all is being captured is creation and delete of objects, most of them in tempdb

Not really an emergecny more a best practice

Thanks in this case all the ssis does is import text files into sql server table and then archive them

Thanks, for an OLTP I still would argue they should always be on. An in a case where everything is in line sql it would be a must. ...

Wish I had that option, 1200 tables no cluster index, kind of liking getting a bi-plane with jet engines to fly,

I will approach vendor about this. There are 1200 + tables utilized, with lots of inserts and updates. Will probably try to capture trace

Thanks, they do have a create_date on almost all their tables, never thought of that.