crackyourinterview.com


How do we handle when SQL SERVER Agent is missing from SSMS?
Question Posted on 21 Nov 2022Home >> SQL Server >> SSMS >> How do we handle when SQL SERVER Agent is missing from SSMS?

How do we handle when SQL SERVER Agent is missing from SSMS?
This a happen some time that SQL Server Agent is missing from SSMS. And it is possible that SSMS will not shows the SQl Server Agent node or it will shows the agent node and this will not be further expanded. And this issue is very common issue at clients. And to solver this issue we use below code.


sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Agent XPs', 1;
GO
RECONFIGURE
GO


Once we run the above code this will refresh our SSMS and will display in SQL Server Agent node in our SSMS.
0
0



.


Most Visited Questions:-

Deep Learning Questions Answers
Below are the different Deep Leaning Questions and answer a More...

Continuous Integration Questions Answers
Below are the 20 odd questions for CI or Continuous Integra More...

Microservices Architecture Questions Answers
Below are the different questions on Microservices Architec More...

Derived relationships in Association Rule Mining are represented in the form of __________.
Derived relationships in Association Rule Mining are repres More...

50 Latest questions on Azure
Below are the latest 50 odd questions on azure. These are m More...




Other Important Questions

How and why we can disable IntelliSense in SQL Server Management Studio?

How do we handle when SQL SERVER Agent is missing from SSMS?

Can we install non English language version of SSMS(SQL Server Management Studio)?






@2014-2022 Crackyourinterview (All rights reserved)
Privacy Policy - Disclaimer - Sitemap