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


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



enter image description here

  • 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. Nov 21 at 2:37
  • Hi Rohit, error is already displayed on the Title, hope you can help me out with it. Thanks.
    – Marvin
    Nov 21 at 3:47
  • What version of SSMS are you using?
    – J.D.
    Nov 21 at 12:03
  • Hi J.D, were using SQL Server 2012 x64 STD.
    – Marvin
    Nov 22 at 2:00
  • Can you select "manually" from the mentioned view? (SELECT TOP 10 * FROM sys.all_objects) Nov 24 at 8:49


Your Answer

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

Browse other questions tagged or ask your own question.