Thanks Evgeny

That is one of the 2 options presented, yes.  What I don't know enough of is how VM is going to impact an ever growing data load,...

Thanks for the reply.  So degraded is one thing, but will the replication be broken is the other part of the question. 🙂

* Update *
I thought I'd...

Thanks Steve

I've been wondering about the DT2 columns.  The columns in the originating and target table are DT2 columns.  Any idea how Snapshot Replication is using BCP and...

Thanks Thom

I'm not at a point where we're ready to try SSMS 2017 due to third party apps used with SSMS not being ready yet.  I really need...

Still not fixed on my systems.  Just rant the latest update for SSMS (13.0.16106.4) and it installed fine.  Still no update on Report Viewer. :/

KDS

No firewall issues, as the rest of the update check marked fine, per image (thanks for the hosting shot).

Also, sorry for typo on version in the subject line (13.0.1601.5 is...

The restored database to another instance. Is the instance on different physical hardware than the one it came from? Has fragmentation across the drives been checked? Not...

Well, if anyone is interested, I solved this problem 2 different ways. Let me just preface this with one detail. The server I was having the issue on...

Ok, I got it to work but don't really know the explanation. I can explain what I did, but not why it worked. I had to not make...

The topic was how to disable and enable, and appeared to be seeking a way to do so without application layer changes. As a permanent solution, there are other...

Assuming you obviously can't make a program change, even for adding optional parameters to stored procedure call, there are safe and relatively easy measures.

With business and management approvals,...

+1 to Gail (GilaMonster)

The CTE should do the trick for you. As was said, calling the table Tmp doesn't make it temporary. Using an INTO #Tmp .... is...

To answer another side of it, it appears you have it set to run every 2 weeks (every other week) on Sunday at 12:30AM. Sorry I didn't put all...

New Born DBA (9/12/2014)

---

I wanted to create a job which would runs every other Sunday. This job would reorganize indexes which are less than 30% fragmented and it would rebuild...