Microsoft SQL Server vs. SQL Server Management Studio

c# visual-studio-2012 ssms-2012 database-diagram
hrskrs picture hrskrs · Mar 8, 2014 · Viewed 27.7k times · Source

What is the difference between Microsoft SQL Server and SQL Server Management Studio (SSMS) and how can I integrate SSMS in Visual Studio 2012 so I can use database diagrams?

Answer

Jim Aho picture Jim Aho · Mar 7, 2017

Credit to marc_s:

SQL Server = database engine; SQL Server Management Studio = GUI Administration Tool for working against the SQL Server engine

Related questions

Is there a format code shortcut for Visual Studio?

In Eclipse there is a shortcut, Ctrl+Shift+F, that re-indents code and fixes comments and blank lines. Is there an equivalent for Visual Studio 2010?

Read More
Visual Studio "Could not copy" .... during build

I keep getting this error during the build of my VS2012 C# project Error 41 Could not copy "obj\Debug\WeinGartner.WeinCad.exe" to "bin\Debug\WeinGartner.WeinCad.exe". Exceeded retry count of 10. Failed. Error 42 Unable to copy file "obj\Debug\…

Read More
How to reference Microsoft.Office.Interop.Excel dll?

I had developed a system that deals with excel sheets in 2006 using MS VS 2005. Now, I can not use the same reference with MS VS 2012. var app = new Microsoft.Office.Interop.Excel.Application(); Workbooks wbs = app.Workbooks;

Read More