Try scripting it, recreating it (you might need to change a little syntax)and then use bcp to dump your data and suck it back in.

If it is network blips causing the problems, then I've found robocopy a great tool.  It can recover and keep copying a file when file copies can't make it intact in...

I've used SQL mail on clusters and have had issues where mail would stop sending and I couldn't pinpiont why.  I think the issue was with the mutliple instances (active/active)...

I'm not sure it works in anything but the gui conenction box in QA.  Never tested anywhere else.  It's a good quick way to make sure your protocols are working...

OK, called an old friend I thought had a copy of the documentation and here is the answer

instead of entering <servername> on the connection box enter:

tcp:<servername>  -- tcp connection

np:<servername>   --...

I know this can be done.  I've done it before.  You can specify in QA when you enter the server name the protocol to use to connect. 

I use Veritas SQL agents to backup full backups strait to tape.  In another life at another company I had problems with tape backups but so far all is well. ...

I have seen otherwise capable people (of being on a team not the team leader) getting bad reviews and bottom 10% reviews when asked to do jobs they were ill-suited for. ...

In a previous employer, I supported Active/Active clusters on NT4/SQL7, windows 2000/SQL2000, windows 2003/sql2000 some with GEOSPan and long distance clusters.  They work great for business continuance but not so good...

Is AWE the only issue with memory issue > 2G?  What about 4 G with the /3G switch set?

I'm not sure what I did different OTHERTHAN I noticed you said tht the line must end with a space so I carfully placed the string back in and hit...

OK, more information.

The error I'm getting when trying to use a parameter in the dynamic query used for the drop down selection:

The  expression for the query ‘hardcoded_selectionquery’ contains an error:...

OK, I'm frustrated.  If I take to long to write my reply it disspaears when I hit preview....

Let me try this again.

Your exactly right with the second option - I'm...

From my experience, it made me nervous to update only one instance after knowing that there were certain things the instance will share and at least some of this is...

I've found on occasion that EM scripts things very funny.  I did some research and found that some syntaxes that aren't supported in all versions that EM supports will not be...