Category Archives: SSMS
-
What does the User Mapping tab of Login Properties really tell us.
4June 24, 2019 by Kenneth Fisher
In case it’s not clear, we are talking about the Login Properties GUI in SQL Server Management Studio (SSMS). Now, …
Continue reading -
A transport-level error has occurred when sending the request to the server.
4March 27, 2019 by Kenneth Fisher
Brent recently did a post called In Azure SQL DB, what does “The connection is broken and recovery is not …
Continue reading -
What version of SQL is SSMS scripting for?
Leave a commentMarch 25, 2019 by Kenneth Fisher
Recently (honestly it’s been a few years now) Microsoft split the lifecycle for SSMS out from the general SQL Server …
Continue reading -
Error in SSMS: Attempted to read or write protected memory.
2February 18, 2019 by Kenneth Fisher
There are a lot of reasons to write a blog post. One of my favorites is when I’ve been asked …
Continue reading -
Savings changes is not permitted. The changes you have made require the following tables to be dropped and re-created.
4December 17, 2018 by Kenneth Fisher
Microsoft does a lot of things to try to help us not shoot ourselves in the foot. This little error …
Continue reading -
SQL Homework – December 2018 – Configure SSMS
Leave a commentDecember 3, 2018 by Kenneth Fisher
I’ve committed to posting a piece of homework for you to do each month. I post at the beginning of …
Continue reading -
Dealing with multiple AD accounts
8November 19, 2018 by Kenneth Fisher
To help promote the seperation of duties one of the things my company has done is to divide our permissions …
Continue reading -
What is the Object Explorer Details tab good for?
Leave a commentOctober 17, 2018 by Kenneth Fisher
For a long time there I would see the Object Explorer Details tab show up when I opened SSMS (SQL …
Continue reading -
Copying formatted text out of a grid column.
3August 27, 2018 by Kenneth Fisher
I was reading a post today by Bert Wagner (b/t). Displaying Long Variable Values in SQL Server By the way, …
Continue reading -
Putting Object Explorer etc on the right side of SSMS rather than the left.
1August 8, 2018 by Kenneth Fisher
A while back I was given the advice Move your tabs (Object Explorer etc) to the right side of SSMS. …
Continue reading
