mirroring has automatic failover and failback?

how is it on the client side? with CA it seems as though the clients would drop connection to database, then they just log out...

i did the webex with CA and really like it, still considering it, but now trying to read more about mirroring

(the cost is certainly better)

thanks for the input thus far.

ok, what I need is no downtime, (that's why I was looking at the CA product, the db's are mirrored and if primary goes down or needs maint, the secondary...

Gianluca Sartori (6/17/2010)

---

If you just want to update table Client, you must use an UPDATE statement:

UPDATE DB1.dbo.Client

SET Notes = DB2.dbo.AllNotes.notes

FROM DB1.dbo.Client

INNER JOIN DB2.dbo.AllNotes

ON cid=UserID

If you also want...

Ok, so I disabled the trigger. then I got a constraint error so I disbaled the constraint checking on insert. then I get a Primary Key error about inserting duplicate...

I didn't design DB1 so I can't say for sure. But I can't find anything.

I imported a bunch of stuff earlier and it went fine

I just tried with one client...

Stefan_G (6/16/2010)

---

OK, now I think I understand what you want.

Try this:

select

userid,

substring((

select ' : ' + cast(memo as varchar(max)) + ' , ' + cast(memodate as varchar(max))

from Notes n2

where...

I want the same thing to happen for every userid.

I want all rows of memos for each...

this is basic of table

RecordIDUserIDMemo MemoDate

154625533287To clt today.2010-05-25 00:00:00.000

154552033287Approved by AJ2010-05-24 00:00:00.000

154629133287Lm giving clt id#...

Stefan_G (6/16/2010)

---

_taz_ (6/16/2010)

---

Kingston Dhasian (6/16/2010)

---

Try this one

DECLARE @Notes varchar(MAX)

-- Here you are assigning a value to a variable

SELECT @Notes = COALESCE(@Notes + ':', '') +

...

Kingston Dhasian (6/16/2010)

---

Try this one

DECLARE @Notes varchar(MAX)

-- Here you are assigning a value to a variable

SELECT @Notes = COALESCE(@Notes + ':', '') +

CAST(Memo...

I tried

DECLARE @Notes varchar(MAX)

SELECT @Notes = COALESCE(@Notes + ':', '') +

CAST(Memo AS varchar(max))+' '+CAST(MemoDate AS varchar(max)),UserID

FROM Notes

Select @Notes as 'All Notes'

and

DECLARE @Notes varchar(MAX)

SELECT @Notes = COALESCE(@Notes...

yeah, it will be all userid's I was just testing with one to see it it was pulling all memos

the way it was, it was returning all the notes (for the one client I tried) doing it your way only returned the last entry and put the userid in...

Wayne, thanks that's what I needed

Jeff, I really hadn't thought about that but you are right. but once I get this column populated correctly, I can merge it with my...