Background When SQL Server Management Studio ( SSMS ) is ran against an Amazon/RDS SQL Server instance, we can get a little error. Error The error reads :- Error Message Image Text Error Message - Advanced Information Image Text Explanation Looking at the Stack Trace the error occurs at :- Microsoft.SqlServer.Management.Smo.Agent.JobServer.get_MsxServerName() TroubleShooting What is the … Continue reading SSMS – AWS/RDS – Error – “The EXECUTE permission was denied on the object ‘xp_regread'”
Background Needing to deploy SSIS packages on a new machine, noticed that the SQL Server Instance has yet to be provisioned with an Integration Services Catalog. Let us address fairly quickly. Outline Launch SQL Server Management Studio ( SSMS ) Connect to the SQL Server Instance Navigate to the Integration Services Catalog Create Catalog Right … Continue reading SSMS :- Integration Services Catalog – Create Catalog – Version Compatibility
Background Ever since I can remember, transact SQL select and print statements send do not share same output area; especially when the the "Results To" is Grid. SQL For instance this SQL Statements produces both a Grid and a Text Output. Code Output Grid Text Another Way Like TC, Tevin Campbell, another way, is … Continue reading SSMS – Having “Select and Print” Share Same Output Space with sqlcmd mode
Background Tried to access a Query's execution plan and ran into a wall. The error is pasted below. Error Message Image Text Resolution Looked more into it. And, determined that I was using SQL Server Management Studio v2005. In this case I should be using a newer version, v2014 to be exact.
Background Drew a quick error running Sql Server Management Studio (SSMS). Error Text The error reads :- Index was outside the bounds of the array. (Microsoft.SqlServer.Smo) Image Explanation Error reads Microsoft.SqlServer.Smo Index was outside the bounds of the array Recreate Tried connecting to Microsoft SQL Server v2017 instance with Sql Server Management Studio v2008. TroubleShooting … Continue reading SSMS – v2008 – Error – “Index was outside the bounds of the array. (Microsoft.SqlServer.Smo)”
Background There is a lot of good in SQL Server Management Studio ( SSMS). But, it appears there is a bit of an achilles heels when it comes to managing SQL Server Agent Proxies. SQL Server Management Studio ( SSMS) Proxy Registered Proxies As of SSMS v 17.9, it does not appear that SSMS exposes … Continue reading SQL Server – SSMS – SQL Server Agents Proxy Management
Background One of my favorite go to tool with SQL Server Query troubleshooting is to simple use SQL Server Management Studio (SSMS) to compare the query plans generated via running the same SQL across different machines or SQL Server Versions.\ Use To use, please follow these simple steps :- Invoke SSMS Query 1 Enable "Include … Continue reading SQL Server – SSMS – Query Plan – Compare