Category SSMS

SSMS 2016 Run As issue on Windows 10

As highlighted in a number of Connect items, attempting to run SQL Server Management Studio 2016 as another user (e.g. by using Shift + right-click) results in a message stating that “This task requires the application to have elevated permissions”. This issue affects Windows 10 1607 & 1703 but is apparently resolved by KB4016240. Prior to that, […]

Script multiple objects in SSMS

Aim: To script multiple database objects using the Object Explorer Details window in SQL Server Management Studio (SSMS). It’s not possible to script multiple objects at the same time from the Object Explorer window in SSMS. However, by opening the Object Explorer Details window from the View menu, you can navigate to the relevant folder […]

Kevin Kline

Career and Technical Advice for the IT Professional

TroubleshootingSQL

Explaining the bits and bytes of SQL Server and Azure

SQL Authority with Pinal Dave

SQL Server Performance Tuning Expert

Powershellshocked

A blog about PowerShell and general Windows sysadmin stuff

Simon Learning SQL Server

I'm trying to become "better" at SQL Server and data - here's how I'm doing it!