What will happen with CATALOG_COLLATION and Case Sensitive vs Case Insensitive
First published on MSDN on Feb 15, 2018 One of the options available when creating a database is the CATALOG_COLLATION, by default this is going to be SQL_Latin1_General_CP1_CI_AS , even if you take the trouble of specifying a database collation , the catalog collation will be SQL_Latin1_General_CP1_CI_AS unless you say otherwise.Lesson Learned #21: There is not enough space on the disk exporting BacPac using SSMS
First published on MSDN on Feb 02, 2017 Depending on the size of your database when you export/import the data to/from a bacpac using SQL SERVER Management Studio you could see an error like this one: There is not enough space on the disk, however, the destination/source of the data file has a lot of free space.Helpful SQL Tools and Tips for Test Engineers - Part 1
Today we will review a tool he created to make the life easier for anyone who spends a lot of time working on SQL Server Management Studio (SSMS). This tool will allow you a quicker and more efficient way to connect to several SQL Servers through SSMS.
How It Works: What is behind the SQLCLR wait category in SQL Server 2008 Activity Monitor
First published on MSDN on Dec 02, 2008 I was asked a question as the CSS First Aid Station at SQL PASS 2008 where the Activity Monitor kept showing the SQLCLR wait category as the top waiter, even when no other activity was going on.
关于SSMS的安装问题，sql-server2019可以整行安装，但是在安装ssms时发生setup程序无反应。
1.首先排除了杀毒软件 2.尝试了给予ssms-setup最高管理员权限运行以及兼容性的调试。 3.排除了存在遗留ssms的安装残留可能性 4.从第一次运行setup程序后所生成的log文件对比最后一次的log内容一致。 附上最新log文件内容： [1858:2C34][2022-01-11T09:53:03]i001: Burn v3.8.1128.0, Windows v6.1 (Build 7600: Service Pack 0), path: E:\BaiduNetdiskDownload\SSMS-Setup-CHS.exe, cmdline: '-burn.unelevated BurnPipe.{F1C80CE4-F18D-44EE-90F5-D848C6AF7A9D} {179549FA-64C9-43A7-B9A3-4A6F3EB95843} 8656' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'SSMSINSTALLROOT' to value '[ProgramFilesFolder]Microsoft SQL Server Management Studio 18' [1858:2C34][2022-01-11T09:53:03]i000: Initializing numeric variable 'SSMSInstallExists' to value '0' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'SSMSInstalledLanguageKeyExists' to value 'false' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'SSMSInstalledLanguageMatch' to value 'true' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'SSMS18PreReleaseDetected' to value 'false' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'SSMS18InstalledVersion' to value '' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'AzureDataStudioInstalledVersion' to value '' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'AzureDataStudioInstalledVersionInsider' to value '' [1858:2C34][2022-01-11T09:53:03]i000: Initializing numeric variable 'AzureDataStudioInstallExists' to value '0' [1858:2C34][2022-01-11T09:53:03]i000: Initializing numeric variable 'AzureDataStudioInstallExistsInsider' to value '0' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'AzureDataStudioVersion' to value '1.32.0' [1858:2C34][2022-01-11T09:53:03]i000: Initializing numeric variable 'DONOTINSTALLAZUREDATASTUDIO' to value '0' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'ProductVersionVar' to value '15.0.18390.0' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'HeaderText' to value '版本 18.10' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'SubHeaderText' to value 'Microsoft SQL Server Management Studio(内含Azure Data Studio)' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'LicenseTermsSSMSUrl' to value 'https://go.microsoft.com/fwlink/?LinkID=620835&clcid=0x[System.Convert]::ToInt32(2052)' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'LicenseTermsADSUrl' to value 'https://go.microsoft.com/fwlink/?linkid=2140322&clcid=0x[System.Convert]::ToInt32(2052)' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'PreviewStatementUrl' to value 'https://go.microsoft.com/fwlink/?LinkID=824140' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'TelemetryDocumentationUrl' to value 'https://go.microsoft.com/fwlink/?LinkID=869476' [1858:2C34][2022-01-11T09:53:03]i000: Initializing numeric variable 'InstallerLcid' to value '2052' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'CancelText' to value '取消' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'CloseText' to value '关闭(_C)' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'ContinuePastWarningText' to value '是否要继续?' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'InstallText' to value '安装(_I)' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'LicenseTermsSSMSText' to value 'SQL Server Management Studio' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'LicenseTermsADSText' to value 'Azure Data Studio' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'LoadingPackagesText' to value '正在加载程序包。请稍候...' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'OverallProgressText' to value '总体进度' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'PackageProgressText' to value '程序包进度' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'PrivacyStatementText' to value '隐私声明' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'TelemetryDocumentationText' to value '文档' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'PrivacyDisclaimerText' to value '为了有助于改进产品，SQL Server Management Studio 会向 Microsoft 传输安装体验信息，以及其他使用情况和性能数据。若要详细了解数据处理和隐私控制，以及在安装后禁用收集此信息，请参阅 {documentation}。' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'RepairText' to value '修复' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'RestartText' to value '重新启动' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'SetupBlockedDescriptionText' to value '出了点问题，导致安装程序无法继续。' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'SetupBlockedText' to value '已阻止安装程序' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'SetupCanceledDescriptionText' to value '已取消安装操作。' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'SetupCanceledText' to value '已取消安装程序' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'SetupCompletedText' to value '已完成安装程序' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'SetupFailedDescriptionText' to value '安装过程中出错了。' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'SetupFailedText' to value '安装失败' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'SetupHelpDescriptionText' to value '/install | /repair | /uninstall - 安装、修复或卸载。安装为默认操作。 /passive | /quiet - 在无提示的情况下显示最小 UI 或不显示 UI 和提示。默认显示 UI 和所有提示。 /norestart - 取消任何重启尝试。默认情况下，UI 会在重启前显示提示。 /log <日志文件前缀> - SSMS 安装程序日志的前缀。默认在 %TEMP%\SSMSSetup 下创建日志文件。 SSMSInstallRoot=<SSMS 位置的路径>。默认为 {0}。' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'SetupHelpText' to value '安装程序帮助' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'SetupInstalledText' to value '已成功安装所有指定的组件。' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'SetupLayoutText' to value '已完成布局操作。' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'SetupLogText' to value '单击此处查看日志文件。' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'SetupProgressText' to value '安装进度' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'SetupRepairedText' to value '已成功修复所有指定的组件。' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'SetupRestartDescriptionText' to value '需要先重启计算机，然后安装程序才能继续。' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'SetupRestartText' to value '需要重启才能完成安装程序。' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'SetupUninstalledText' to value '已成功卸载所有指定的组件。' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'SetupWarningDescriptionText' to value '以下问题可能会影响已安装的应用程序。' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'SetupWarningText' to value '安装警告' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'TermsAndConditionText' to value '单击“安装”按钮即表示我确认接受 {SQL Server Management Studio} 及 {Azure Data Studio} 的{Privacy Statement}和许可条款。' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'UninstallText' to value '卸载' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'WelcomeInstallText' to value '欢迎使用。单击“安装”，立即开始体验吧。' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'YesText' to value '是' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'RestartAlreadyPending' to value '挂起的重启正在阻止完成安装过程。请重启计算机并再次运行安装程序。' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'AnotherInstallRunning' to value '由于当前正在运行另一个安装，安装程序被阻止。请先完成另一个安装，然后在必要时重启计算机。' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'SSMSCurrentlyRunning' to value 'SSMS 当前正在运行。请关闭 SSMS 所有已打开的实例并重新运行此安装程序。' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'AzureDataStudioCurrentlyRunning' to value 'Azure Data Studio 目前正在运行。请先关闭所有打开的 Azure Data Studio 实例，再重新运行此安装程序。' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'MinimizeButtonAccessibleName' to value '最小化' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'Win10OrWS2016NotSupported' to value '不支持此版本的 Windows 10 或 Windows Server 2016。请升级到版本 1607 或更高版本。' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'IsUpgradeScenario' to value 'false' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'ChangeText' to value '更改(_H)' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'LocationText' to value '位置(_L):' [1858:2C34][2022-01-11T09:53:03]i000: Initializing string variable 'InvalidLocationText' to value '位置无效。请输入有效的位置以继续。' [1858:2C34][2022-01-11T09:53:03]i000: Setting string variable 'WixBundleLog' to value 'C:\Users\ADMINI~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-CHS_20220111095303.log' [1858:2C34][2022-01-11T09:53:03]i000: Setting string variable 'WixBundleOriginalSource' to value 'E:\BaiduNetdiskDownload\SSMS-Setup-CHS.exe' [1858:2C34][2022-01-11T09:53:03]i000: Setting string variable 'WixBundleName' to value 'Microsoft SQL Server Management Studio - 18.10' [1858:2C34][2022-01-11T09:53:03]i000: Loading managed bootstrapper application. [1858:2C34][2022-01-11T09:53:03]e000: Error 0x80131902: Failed to create the managed bootstrapper application. [1858:2C34][2022-01-11T09:53:03]e000: Error 0x80131902: Failed to create UX. [1858:2C34][2022-01-11T09:53:03]e000: Error 0x80131902: Failed to load UX. [1858:2C34][2022-01-11T09:53:03]e000: Error 0x80131902: Failed while running [1858:2C34][2022-01-11T09:53:03]i410: Variable: AnotherInstallRunning = 由于当前正在运行另一个安装，安装程序被阻止。请先完成另一个安装，然后在必要时重启计算机。 [1858:2C34][2022-01-11T09:53:03]i410: Variable: AzureDataStudioCurrentlyRunning = Azure Data Studio 目前正在运行。请先关闭所有打开的 Azure Data Studio 实例，再重新运行此安装程序。 [1858:2C34][2022-01-11T09:53:03]i410: Variable: AzureDataStudioInstalledVersion = [1858:2C34][2022-01-11T09:53:03]i410: Variable: AzureDataStudioInstalledVersionInsider = [1858:2C34][2022-01-11T09:53:03]i410: Variable: AzureDataStudioInstallExists = 0 [1858:2C34][2022-01-11T09:53:03]i410: Variable: AzureDataStudioInstallExistsInsider = 0 [1858:2C34][2022-01-11T09:53:03]i410: Variable: AzureDataStudioVersion = 1.32.0 [1858:2C34][2022-01-11T09:53:03]i410: Variable: CancelText = 取消 [1858:2C34][2022-01-11T09:53:03]i410: Variable: ChangeText = 更改(_H) [1858:2C34][2022-01-11T09:53:03]i410: Variable: CloseText = 关闭(_C) [1858:2C34][2022-01-11T09:53:03]i410: Variable: ContinuePastWarningText = 是否要继续? [1858:2C34][2022-01-11T09:53:03]i410: Variable: DONOTINSTALLAZUREDATASTUDIO = 0 [1858:2C34][2022-01-11T09:53:03]i410: Variable: HeaderText = 版本 18.10 [1858:2C34][2022-01-11T09:53:03]i410: Variable: InstallerLcid = 2052 [1858:2C34][2022-01-11T09:53:03]i410: Variable: InstallText = 安装(_I) [1858:2C34][2022-01-11T09:53:03]i410: Variable: InvalidLocationText = 位置无效。请输入有效的位置以继续。 [1858:2C34][2022-01-11T09:53:03]i410: Variable: IsUpgradeScenario = false [1858:2C34][2022-01-11T09:53:03]i410: Variable: LicenseTermsADSText = Azure Data Studio [1858:2C34][2022-01-11T09:53:03]i410: Variable: LicenseTermsADSUrl = https://go.microsoft.com/fwlink/?linkid=2140322&clcid=0x::ToInt32(2052) [1858:2C34][2022-01-11T09:53:03]i410: Variable: LicenseTermsSSMSText = SQL Server Management Studio [1858:2C34][2022-01-11T09:53:03]i410: Variable: LicenseTermsSSMSUrl = https://go.microsoft.com/fwlink/?LinkID=620835&clcid=0x::ToInt32(2052) [1858:2C34][2022-01-11T09:53:03]i410: Variable: LoadingPackagesText = 正在加载程序包。请稍候... [1858:2C34][2022-01-11T09:53:03]i410: Variable: LocationText = 位置(_L): [1858:2C34][2022-01-11T09:53:03]i410: Variable: MinimizeButtonAccessibleName = 最小化 [1858:2C34][2022-01-11T09:53:03]i410: Variable: OverallProgressText = 总体进度 [1858:2C34][2022-01-11T09:53:03]i410: Variable: PackageProgressText = 程序包进度 [1858:2C34][2022-01-11T09:53:03]i410: Variable: PreviewStatementUrl = https://go.microsoft.com/fwlink/?LinkID=824140 [1858:2C34][2022-01-11T09:53:03]i410: Variable: PrivacyDisclaimerText = 为了有助于改进产品，SQL Server Management Studio 会向 Microsoft 传输安装体验信息，以及其他使用情况和性能数据。若要详细了解数据处理和隐私控制，以及在安装后禁用收集此信息，请参阅 {documentation}。 [1858:2C34][2022-01-11T09:53:03]i410: Variable: PrivacyStatementText = 隐私声明 [1858:2C34][2022-01-11T09:53:03]i410: Variable: ProductVersionVar = 15.0.18390.0 [1858:2C34][2022-01-11T09:53:03]i410: Variable: RepairText = 修复 [1858:2C34][2022-01-11T09:53:03]i410: Variable: RestartAlreadyPending = 挂起的重启正在阻止完成安装过程。请重启计算机并再次运行安装程序。 [1858:2C34][2022-01-11T09:53:03]i410: Variable: RestartText = 重新启动 [1858:2C34][2022-01-11T09:53:03]i410: Variable: SetupBlockedDescriptionText = 出了点问题，导致安装程序无法继续。 [1858:2C34][2022-01-11T09:53:03]i410: Variable: SetupBlockedText = 已阻止安装程序 [1858:2C34][2022-01-11T09:53:03]i410: Variable: SetupCanceledDescriptionText = 已取消安装操作。 [1858:2C34][2022-01-11T09:53:03]i410: Variable: SetupCanceledText = 已取消安装程序 [1858:2C34][2022-01-11T09:53:03]i410: Variable: SetupCompletedText = 已完成安装程序 [1858:2C34][2022-01-11T09:53:03]i410: Variable: SetupFailedDescriptionText = 安装过程中出错了。 [1858:2C34][2022-01-11T09:53:03]i410: Variable: SetupFailedText = 安装失败 [1858:2C34][2022-01-11T09:53:03]i410: Variable: SetupHelpDescriptionText = /install | /repair | /uninstall - 安装、修复或卸载。安装为默认操作。 /passive | /quiet - 在无提示的情况下显示最小 UI 或不显示 UI 和提示。默认显示 UI 和所有提示。 /norestart - 取消任何重启尝试。默认情况下，UI 会在重启前显示提示。 /log <日志文件前缀> - SSMS 安装程序日志的前缀。默认在 %TEMP%\SSMSSetup 下创建日志文件。 SSMSInstallRoot=<SSMS 位置的路径>。默认为 {0}。 [1858:2C34][2022-01-11T09:53:03]i410: Variable: SetupHelpText = 安装程序帮助 [1858:2C34][2022-01-11T09:53:03]i410: Variable: SetupInstalledText = 已成功安装所有指定的组件。 [1858:2C34][2022-01-11T09:53:03]i410: Variable: SetupLayoutText = 已完成布局操作。 [1858:2C34][2022-01-11T09:53:03]i410: Variable: SetupLogText = 单击此处查看日志文件。 [1858:2C34][2022-01-11T09:53:03]i410: Variable: SetupProgressText = 安装进度 [1858:2C34][2022-01-11T09:53:03]i410: Variable: SetupRepairedText = 已成功修复所有指定的组件。 [1858:2C34][2022-01-11T09:53:03]i410: Variable: SetupRestartDescriptionText = 需要先重启计算机，然后安装程序才能继续。 [1858:2C34][2022-01-11T09:53:03]i410: Variable: SetupRestartText = 需要重启才能完成安装程序。 [1858:2C34][2022-01-11T09:53:03]i410: Variable: SetupUninstalledText = 已成功卸载所有指定的组件。 [1858:2C34][2022-01-11T09:53:03]i410: Variable: SetupWarningDescriptionText = 以下问题可能会影响已安装的应用程序。 [1858:2C34][2022-01-11T09:53:03]i410: Variable: SetupWarningText = 安装警告 [1858:2C34][2022-01-11T09:53:03]i410: Variable: SSMS18InstalledVersion = [1858:2C34][2022-01-11T09:53:03]i410: Variable: SSMS18PreReleaseDetected = false [1858:2C34][2022-01-11T09:53:03]i410: Variable: SSMSCurrentlyRunning = SSMS 当前正在运行。请关闭 SSMS 所有已打开的实例并重新运行此安装程序。 [1858:2C34][2022-01-11T09:53:03]i410: Variable: SSMSInstalledLanguageKeyExists = false [1858:2C34][2022-01-11T09:53:03]i410: Variable: SSMSInstalledLanguageMatch = true [1858:2C34][2022-01-11T09:53:03]i410: Variable: SSMSInstallExists = 0 [1858:2C34][2022-01-11T09:53:03]i410: Variable: SSMSINSTALLROOT = C:\Program Files (x86)\Microsoft SQL Server Management Studio 18 [1858:2C34][2022-01-11T09:53:03]i410: Variable: SubHeaderText = Microsoft SQL Server Management Studio(内含Azure Data Studio) [1858:2C34][2022-01-11T09:53:03]i410: Variable: TelemetryDocumentationText = 文档 [1858:2C34][2022-01-11T09:53:03]i410: Variable: TelemetryDocumentationUrl = https://go.microsoft.com/fwlink/?LinkID=869476 [1858:2C34][2022-01-11T09:53:03]i410: Variable: TermsAndConditionText = 单击“安装”按钮即表示我确认接受 {SQL Server Management Studio} 及 {Azure Data Studio} 的{Privacy Statement}和许可条款。 [1858:2C34][2022-01-11T09:53:03]i410: Variable: UninstallText = 卸载 [1858:2C34][2022-01-11T09:53:03]i410: Variable: WelcomeInstallText = 欢迎使用。单击“安装”，立即开始体验吧。 [1858:2C34][2022-01-11T09:53:03]i410: Variable: Win10OrWS2016NotSupported = 不支持此版本的 Windows 10 或 Windows Server 2016。请升级到版本 1607 或更高版本。 [1858:2C34][2022-01-11T09:53:03]i410: Variable: WixBundleAction = 4 [1858:2C34][2022-01-11T09:53:03]i410: Variable: WixBundleElevated = 1 [1858:2C34][2022-01-11T09:53:03]i410: Variable: WixBundleLog = C:\Users\ADMINI~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-CHS_20220111095303.log [1858:2C34][2022-01-11T09:53:03]i410: Variable: WixBundleManufacturer = Microsoft Corporation [1858:2C34][2022-01-11T09:53:03]i410: Variable: WixBundleName = Microsoft SQL Server Management Studio - 18.10 [1858:2C34][2022-01-11T09:53:03]i410: Variable: WixBundleOriginalSource = E:\BaiduNetdiskDownload\SSMS-Setup-CHS.exe [1858:2C34][2022-01-11T09:53:03]i410: Variable: WixBundleProviderKey = {617634cc-0b11-4aaa-b840-a1eeeab06fdd} [1858:2C34][2022-01-11T09:53:03]i410: Variable: WixBundleTag = [1858:2C34][2022-01-11T09:53:03]i410: Variable: WixBundleVersion = 15.0.18390.0 [1858:2C34][2022-01-11T09:53:03]i410: Variable: YesText = 是 [1858:2C34][2022-01-11T09:53:03]e000: Error 0x80131902: Failed to run per-user mode. [1858:2C34][2022-01-11T09:53:06]i007: Exit code: 0x80131902, restarting: No 麻烦您可以帮我解决该问题，并使得我学会该如何处理此类问题。谢谢SQL Server Config Manager Error "MMC could not create the snap-in"
Hi, I have seen this error elsewhere online. I have gone to mmc to enable the snap in and I still have had no fix. My computer is running Windows Server 2022, SQL Server Express 2022, and SSMS. I have reinstalled, repaired, and all of the other tricks. Help!Service status watcher in SQL Server Management Studio – How it works
First published on MSDN on Aug 21, 2013 Have you ever wondered about the mechanism using which SQL Server Management Studio(SSMS) - Object Explorer shows the service status for SQL Server and SQL Agent service? We recently worked with a customer on a issue related to this and thought that this might be useful information to share out.
