Async mirroring comes to mind first. Enterprise Edition or Standard? Async mirroring (good for separate geo locations or slower links) is Enterprise only.

It also depends on whether you're talking about failing over to a server in the same physical location. I see you're on a WAN...does this mean the failover server is...

When committed reaches target, visible will reach that same level. Visible and target match on all my instances except 1. Why are you concerned about the visible value? Or just...

Makes sense. Thanks for clarifying.

You still have not provided an actual execution plan. You can save a plan as a .sqlplan file and attach it to the thread.

Chrissy321 (4/25/2012)

---

Thanks all. I think having a usable execution plan is going to take precedent in this case so an IF...ELSE block

would be my best bet.

This is not a paging...

Is the identity column present in the destination? If so you could start your package with an Execute SQL Task to find the MAX value in the destination. Then, using...

You're welcome! I am happy you got a working solution 🙂

Did you set it to "on change prevent"? Did you enable it after creation?

If you cannot get it, export the policy and attach it to this thread and I'll have...

MisLead (4/24/2012)

---

opc.three (4/24/2012)

---

MisLead (4/24/2012)

---

Please refer this. Its exactly what i mean-if you still have some time

I could see if you wanted to tear apart ? into two separate bytes so...

OK, that sounds more sane. I could have understood the example not being representative in terms of the actual characters used, but having the number of characters not be representative...

I have to throw out a blanket-statement here...sorting is expensive and should be left to the presentation layer where possible. The key being where possible, which leaves me an out...

Yes, Windows uses a double-byte character set internally, with encoding UCS-2...which is the same encoding SQL Server...

Re: security holes in pass-through auth (leverages NTLM) existed until recently. Make sure your OS is patched:

Microsoft Security Bulletin MS10-012 - Important > Vulnerabilities in SMB Server Could Allow Remote...

EXEC sys.xp_logininfo

@acctname = 'domain_name\group_name',

@option = 'members'