Recent DiscussionsMost RecentNewest TopicsMost LikesSolutionsTagged:TagRe: Outlining not working in SSMS 18.x and 19.x jbrannick that was my question - and it would be great to confirm. I need someone who has reported the problem to test without any extensions installed (SQL Prompt) or anything else. Re: Outlining not working in SSMS 18.x and 19.x chadbaldwin Hi - my question would be to you (or anyone else who has the issue), whether it also occurs when you do not have any extensions installed. Thanks. Re: "Object reference not set to an instance of an object. (SqlManagerUI)" jainChetan Can you please provide step by step instructions to create the problem that you are seeing? This original item was opened for Azure SQL Managed Instance and editing an Agent Job. You are talking about adding a replica to an AG, so I don't know what steps you are taking, what version of SQL to which you're connecting, etc. Also, please try the latest SSMS 20.x release to see if the problem still occurs there. Re: Outlining not working in SSMS 18.x and 19.x asocorro Do you have any third party extensions installed with SSMS? Re: Outlining not working in SSMS 18.x and 19.x MartinxN you can email it to me - my address is my handle at microsoft.com. Feel free to send a test message first 🙂 Re: Outlining not working in SSMS 18.x and 19.x MartinxN Ok...I'm wondering if it's a combination of settings that you have then. Would you be willing to export your settings file and then share it with me? If so, I can provide my email. Thanks. Re: Outlining not working in SSMS 18.x and 19.x Neilius Thank you for sharing your findings! MartinxN, if you are able to test and confirm, that would be very helpful. I can then update the documentation. Thanks! Re: "Object reference not set to an instance of an object. (SqlManagerUI)"SSMS version 16.0.16091.0 is a preview (19 preview 3). As noted in the reply selected as best response, I noted that I cannot recreate with SSMS 19.3. Please try with that version, or the latest release of SSMS, which is 20.1.Re: "Object reference not set to an instance of an object. (SqlManagerUI)"This is a completely separate issue that originally reported and should be created as a separate issue. If you do that, feel free to share the link here, but you need to provide step-by-step instructions to recreate the error. The information provided above is not detailed enough to try and recreate what you're seeing. Specifically, are you using Import Flat File, or are you using Import Data (from the right-click menu on the database, after selecting Tasks)? If you're using Import Data, are you select Flat File Source for the Data Source, and then what options are you selecting on the General tab? On the Destination page, what data source are you selecting and how are you authenticating? What changes are you making to the data type mapping and can you provide a sample file that is anonymized? Thanks.Re: Outlining not working in SSMS 18.x and 19.xAh, my mistake, I misread it as the Intelliense option. I have this enabled for my local SSMS (version 19 and 20 installed) and have not seen the issue. Do you have any third party extensions installed? I noticed other folks mentioned RedGate Prompt but I am not sure if you have that extension, or any other one installed. Thanks.Re: Outlining not working in SSMS 18.x and 19.xMake sure the setting is enabled...go to Tools > Options > Text Editor > Transact-SQL > IntelliSense, ensure that Outline statements is enabled.Re: "Object reference not set to an instance of an object. (SqlManagerUI)"adamoumagaji I do not have that issue with SSMS 19.3, which is the latest release. Can you please try with SSMS 19.3? Thanks.Re: "Object reference not set to an instance of an object. (SqlManagerUI)" Tessa_new Leonardo_Cursi We have these issues logged internally and will address them in the next release of SSMS. Thank you! Re: "Object reference not set to an instance of an object. (SqlManagerUI)"Hi Leonardo_Cursi - can you please provide the steps to recreate? I just tested with 19.1 against Managed Instance with the following steps: 1. I created a new SQL Agent job that had one step - it just runs a simple select statement (SELECT @@VERSION). 2. I saved the job, and then manually executed it to make sure it worked. (It did.) 3. I then right-clicked on the job and selected Properties. 4. In the properties window, I went to the Steps page, selected the job step, and then selected Edit. 5. I modified the script (added another query - select * from msdb.sys.databases) and then selected OK. 6. I selected OK again from the properties window, and then ran the job again. I did not encounter any errors. If you are able to share your exact steps, that would be helpful to try and recreate the issue here. Thank you.Re: Is Static Data Masking still a thing?Apologies, I was typing too fast. I fixed my original post so it is correct. Yes, talking about STATIC Data Masking.Re: Is Static Data Masking still a thing? Static Data Masking was in preview in SSMS 18, but removed before GA. It’s not something that is on the roadmap at this time. Re: "Object reference not set to an instance of an object. (SqlManagerUI)" Hi all - This issue has been fixed in SSMS 18.11 https://docs.microsoft.com/en-us/sql/ssms/release-notes-ssms?view=sql-server-ver15
Recent Blog ArticlesNewest TopicsMost LikesTagged:TagAnnouncing database instructions and a lot of fixes in SQL Server Management Studio 22.3 The February release of SQL Server Management Studio (SSMS) 22.3 includes bug fixes, improvements, and introduces support for database instructions for GitHub Copilot in SSMS. Announcing GitHub Copilot code completions in SQL Server Management Studio 22.2.1 The January release of SQL Server Management Studio (SSMS) 22.2.1 includes a set of bug fixes and introduces support for code completions for GitHub Copilot in SSMS. Announcing the release of SQL Server Management Studio 22.1 The December release of SQL Server Management Studio (SSMS) 22.1 includes improvements and fixes related to SSMS and GitHub Copilot in SSMS. Announcing the Release of SQL Server Management Studio 22 Preview 5 SQL Server Management Studio (SSMS) 22 Preview 5 was released this week and includes updates to GitHub Copilot in SSMS. Now Available by Popular Demand: GitHub Copilot in SSMS (Preview) GitHub Copilot in SSMS is now available in Preview 3 of SSMS 22! If you’re looking to get help writing, editing, or fixing T-SQL, have questions to ask about your database, and you’d like to use your...What’s next for Copilot in SSMS We released Copilot in SSMS (preview) with the General Availability of SSMS 21 in May of this year. For the uninitiated, the implementation requires creating an endpoint and deployment in Azure OpenA...Copilot in SSMS Survey Copilot in SSMS is now available in Preview and we are asking SSMS users to provide feedback using a survey. Announcing the preview of Copilot in SQL Server Management Studio (SSMS) We are pleased to announce the preview of Copilot in SQL Server Management Studio (SSMS), now available as an optional component in SSMS 21 GA. Copilot in SSMS includes the ability to write, document...SQL Server Management Studio (SSMS) 21 is now generally available (GA) The SQL Tools team is thrilled to announce the general availability of SQL Server Management Studio (SSMS) 21. SSMS 21 GA brings a modern installation and update experience through the Visual Studio...Another Year, Another PM: The SSMS Team Keeps Growing As SQL Server Management Studio (SSMS) continues to move forward, with version 21 and Copilot, the team continues to expand.
MicrosoftMicrosoftMicrosoftMicrosoft
