That's interesting. Strange that it would be different? I assume you did all this yourself on SSMS, so no version difference there.

What was the flaw in teh script?

Also, FTI, SSRS is SQL Server Reporting Services to most people. Replication is just replication.

...

I don't remember where I read it, but some SQL MVP has recently discussed that VM snapshots and sql backups are most likely all that is needed by the...

...

I feel that a lot of complexity results from situations where someone presents the solution, rather than the problem they are trying to solve.  Implementing that solution is the...

AOG is great, ...

In a lot of cases, the AOG itself is still available, but the application is trying to hit a specific node that's temporarily offline. So, making...

You often need a bigger team to build a system than you do to keep it running once implemented, so it makes sense for some of that team to...

I have many years of experience in IT as an employee as well as a consultant.  As I see it you need to hire all of the above.

Hire inexperienced...

When you grow internal staff, does that mean they take on new responsibilities in addition to their old responsibilities? Or does it mean that you move them into a...

As someone who was part of a layoff, only to see a similar role(they added some things I didn't have knowledge of) get posted shortly after my layoff, I...

I use to work at a place that almost always promoted from within. The benefit is that you save about 6 months of time since the new team member...

Strange. All subscribers same version? Same collation?

It's been weird. Bug filed since I noticed I could see things in a summary, but not in the thread. First post appears missing in some

Here is a reply

30 Days for RTO. That's the kind of job I want. Not that I want to take 30 days, but the pressure of minutes is really hard.

Hopefully this helps. Try this code with some names

SELECT
       ContactName,
       SUBSTRING(ContactName, 1, CHARINDEX(' ', ContactName))...