DominantDBA (1/29/2014)

---

I ran a DBCC CHECKDB on B and its fine with different data(correct) in that row than on C. So Im happy with the data in the primary

The same...

Just set up your own automated task to do the copy on a frequent basis. SCHTASKS is built into Windows and is fine for this. SQL Agent could...

The typical quorum for AG implementations is File Share since the vast majority of AGs are based on WSFCs that are NOT using shared storage.

Try Red Gate's or ApexSQL's Data Compare tools. This is right up their alley, and both can be automated I believe. You should be OK with read-only permission...

DominantDBA (1/29/2014)

---

Hi All

Scenario:

A backup is taken and is 50gb uncompressed and is copied from one domain(A) into Domain(B). It is restored and all is well. The same backup file is...

If you are doing this as part of...

If memory serves the only time you want the engine to count a particular field is when you want it to DISCARD NULL values from the count.

Oh, and I would...

I always do this by having a failure step for every actual step that simply sends an email and continues to the next actual step. Very easy to do...

David Webb-CDS (1/27/2014)

---

I'm afraid you're asking for code that would make these two:

21ST CENTURY SERIVES

21ST CENTURY SERVICES

equal, not because they are, but because they SHOULD be. Is that true?...

by my reconning there are no duplicates in your sample data. NOTE: quickie, unverified code

;with a as (select organisationname, address1, row_number() OVER (partition by organisationname, address1 ORDER BY ID)...

It is code that creates code - one of my favorite things!

As I covered in my reply to your PM: ALWAYS verify stuff you get from anyone online before you...

Rod at work (1/27/2014)

---

OK, I think I've found out what the problem was. There wasn't a call to the save routine, in the user control that hosted those 8 data...

Very common issue. The SIDs for the logins are not the same on both boxes. Try this to generate the login on all standby servers so failovers aren't...

SQLKnowItAll (1/27/2014)

---

We have a main database on its own server for our internal application. Several other applications with databases on different servers need this data in real time. We currently...

In addition to what was said already:

1) You may want to add some logging to your code, on both ends, to use for analytics of what was prepped/sent and what...