steveb. (6/27/2011)

---

the problem you are going to have , no matter which method you choose, is that you will need a method of working out which change 'wins' when...

if the can be reconsiled at the end of the day..then you could compress the bak file and restore on the other server at the end of the day.

this could...

I think we need more info...

do these DB's need to be in sync all the time?

can they be reconsiled at the end of the day?

How large of a DB...

open it in BIDS and modify

no it applys...

in SSMS go to that account and verify that it is not locked out.

verify that the account is not locked out..

might be easier to create a new 'test account' to setup the link - use SQL auth.

thanks guys...

I'll just delete them manually

just trying to delete the user

Jsut re-ran dbcc checkdb

everything looks good now...

thanks you guys (and girls) rock...

I know...I know..not setup by me tho..the DBA before me skipped this Db for some odd reason. But that's an excuse I should...

awesome thanks everyone..

works Perfect...thanks Steve

I got it..

thanks again everyone...!

phil..I added a select in between the begin and end....and got incorrect syntax near the keyword 'begin'

...I'm checking...moved, added, deleted parens....can't seem to get it..