If I got you trace flag T1448 can help you (to isolate replication from mirror)- check this:

http://support.microsoft.com/kb/937041

Thanks Perry-

no, it (failover) did not happen yet 🙂

We recently moved standalone server to cluster one but on Active node put Service Start Mode to Automatic one (probably-...

Thanks for your response but actually my question was quite different, sorry:-)- if I restart sql server service on currently active node #1 will it trigger automatic failover to passive...

If I got you correctly- real life scenario:

1) 1-st server 2008- uses TDE- everybody who has access can see real data;

2) 2-nd server 2005- we use 3-rd party app to...

Yes, you can add single (or few) table to existing replication via UI or script without recreating snapshot for whole DB

Eventually found solution (implemented today in Prod)- may be somebody will also use it:-)

1) put DB in Restricted_User mode;

2) break mirror- on Mirror side DB will be in Restoring state

3)...

Couple days ago did this exercise- simply run installation on seconf node with Option- add new node

Just to add my 2 cents as from time to time we are getting same error:

First, IMO restoring 100GB backup for 4+ hours and did not finished- it's pretty slow....

I hope I got you, Gail- optimizer will use this info (stats) to find probably better way to go rather that simple table scan (as last resort).

Thanks Gail/Jeff for...

Sorry, but still not sure- what difference does it (statistics on column not in any index) make? With index stats make sense- optimizer decides on behavior relying on stats. But...

Seems I do not need to post all 82 statements as while preparing them and carefully reading one after one I found 2 indexes (same DB and table- probably same...

Actually I did this already- when yesterday night SP returned error I rerun it again (same indexes) with Print only (no execute)- no errors, all printed statements looks good (no...

Make sense, thanks

But what confuses me is that ALL statements completed successfully (i.e. seems no single failed)

I saw some posts regarding mysterious syntax errors that were results of different DBs...

Only GO command 🙂

I also originally thought there is something extra in text and therefore hard printed whole SP- nothing

Funny enough but when I tried to reproduce error I cannot...

Gail,

But I printed all statements and do not see any '(' in any one

Moreover, as all statements were executed successfully, how SP can return error-

it suppose to fail on...