SQL server Management studio

%3CLINGO-SUB%20id%3D%22lingo-sub-1497861%22%20slang%3D%22en-US%22%3ESQL%20server%20Management%20studio%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1497861%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20few%20queries%20on%20SSMS%2C%3C%2FP%3E%3CP%3E%3CSPAN%3Edoes%20SSMS%20come%20as%20an%20optional%20install%20feature%20with%20SQL%20Server%3F%3C%2FSPAN%3E%3C%2FP%3E%3CUL%3E%3CLI%3Eif%20yes%2C%20is%20there%20a%20difference%20between%20the%20bundled%20one%20and%20the%20standalone%20version%3C%2FLI%3E%3CLI%3Eif%20yes%2C%20is%20there%20a%20difference%20between%20how%20the%20two%20are%20updated.%20eg.%20can%20you%20use%20the%20smss%20standalone%20to%20update%20the%20one%20that%20came%20from%20the%20sql%20server%20installer%20and%20vice%20versa.%3C%2FLI%3E%3C%2FUL%3E%3CP%3ECan%20anyone%20please%20help%20me%20understanding%20about%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%26nbsp%3B%3C%2FP%3E%3CP%3EPavan%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

 

I have few queries on SSMS,

does SSMS come as an optional install feature with SQL Server?

  • if yes, is there a difference between the bundled one and the standalone version
  • if yes, is there a difference between how the two are updated. eg. can you use the smss standalone to update the one that came from the sql server installer and vice versa.

Can anyone please help me understanding about this?

 

Thanks, 

Pavan

1 Reply

Hi @pavan0806 

 

SSMS is now shipped and updated as a separate product on a separate cadence as SQL Server. There is no longer an option to install SSMS with SQL Server setup.