It's worth noting, SSMS is not SQL Server. SSMS is an application to connect to SQL Server. SQL Server is a completely different install. If you've looking to uninstall a...

I realise this isn't an answer to your question, however, why are you using the nolock query hint on every table? Also, please learn how to Alias objects in a...

Also, I noticed you haven't responded on my comment in  regards to NOLOCK. What's your reasoning for using it?

Something a bit more readable (again):
USE [campus_reporting];
GO

CREATE TABLE [dbo].[CmEvent] ([StartDate] [datetime] NULL,
          [EndDate] [datetime] NULL,
          [RemindDate] [datetime] NULL,
          [DueDate] [datetime] NULL,
          [Comments] [text] NOT NULL,
          [Subject]...

Ideally, you need to change your data set up. Is that something you're open to?

Have you checked the "Keep together on one page if possible" checkbox?

Query that is a (little more) readable (white space remove courtesy of SSC's broken text editor) and with the syntax errors removed:
WITH
#ExList AS
  (SELECT DISTINCT
    st.SystudentID,
    CASE...

Perhapsyyou mean can you use SSMS to connect to 2 (or more) servers at the same time? If so, then yes.

Like Phil said, however , this question is...

What do you mean by editting? As in, someone in an application is viewing the record? You'll need to implement your own "locked" system. For example, add a column (maybe...

"disturbing" is an odd choice of word. 🙂

Have you considered using the Dark Theme?