Posts
Sort by recent activity
Find Invalid Objects crash SSMS 18.5 when windows is pinned
When using Find invalid objects and trying to pin the windows as tab SSMS is crashing, it work if I keep the windows floating.This occurs using SSMS 18.5 and SQL Prompt 10 (10.1.5.14730)I have anot...
Keyboard selection using spacebar not detected correctly
Hi,
This is a longstanding bug that I found, but never submitted because I thought it would be corrected eventually.
When we compare 2 databases and use the keyboard spacebar to check or uncheck va...
Non unique indexes and statistics not found
I found that some indexed are not returned by SQL Search, if you type "IX_" in search field, it only return Unique constraint, but not "non unique index"
Also the statistics aren't searched.
Using ...
Synchronize PERSISTED computed column with function
I'm trying to update a function with SCHEMABINDING that is used by a persisted computed column on a table, I always get this error while editing :
** Cannot ALTER 'dbo.getFormatDateHourOnly' becaus...
Search in database trigger
SQL Search don't seem to find text inside database trigger
Checking using Keyboard won't trigger the event
When I'm using the keyboard to check table to synchronise it don't seem to raise the event that the checkbox was checked (or unchecked), it only work when checking using the mouse.
This raise a pro...
SSMS exception and crash with
Since the integration of integration of SQL Compare, SQL Data Compare and SQL Dependency Tracker 2 into SSMS I got exception regulary when popin the context menu on a object in the object explorer....
Crash when no database selected
When I work with SSMS, it append sometime that no database is selected.
When this occur and I try to create a new query, SSMS pop with the connexion prompt.
When I try to start SQL Search in this s...
Invalid script when using VARCHAR(MAX) different collation
I try to migrate data from one database to another that is using 2 different collation. When the field is a varchar(MAX) the script is creating VARCHAR(-1) and fail to execute, I have to open the s...
Intellisense when calling a function inside a function
I'm unable to get the definition of a function when putting my cursor on the function name when used has another function parameter
Here is my 2 functions definition
CREATE FUNCTION [getClassified]...