User Profile
erinstellato
Joined 4 years ago
User Widgets
Recent Discussions
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.1.3KViews0likes0CommentsRe: "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.1.7KViews0likes2CommentsRe: "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.2.3KViews0likes0CommentsRe: Outlining not working in SSMS 18.x and 19.x
Ah, 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.4.4KViews0likes0CommentsRe: "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.61KViews0likes7Comments
Recent Blog Articles
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...8.9KViews2likes18Comments