0

Am trying to expand the Store Procedure in SQL Server 2012 x64 but there is a error prompts. Any Help? Thank you.

TITLE: Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476


ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)


Invalid object name 'sys.all_objects'. (Microsoft SQL Server, Error: 208)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.3128&EvtSrc=MSSQLServer&EvtID=208&LinkId=20476


BUTTONS:

OK

enter image description here

6
  • Please dont use images for text information. How is anyone going to try and search the text for you? If you cant be bothered to type them in, others won't either. Commented Nov 21, 2023 at 2:37
  • Hi Rohit, error is already displayed on the Title, hope you can help me out with it. Thanks.
    – Marvin
    Commented Nov 21, 2023 at 3:47
  • What version of SSMS are you using?
    – J.D.
    Commented Nov 21, 2023 at 12:03
  • Hi J.D, were using SQL Server 2012 x64 STD.
    – Marvin
    Commented Nov 22, 2023 at 2:00
  • Can you select "manually" from the mentioned view? (SELECT TOP 10 * FROM sys.all_objects) Commented Nov 24, 2023 at 8:49

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.