I can no longer open my SQL database Table definition in Visual Studio

Question

Hello Community,

I do not know why this error has occurred recently. before now, I used to open Table definition and edit my tables and stored procedure, but in the past 5 days I have been unable to do that. I get this errors each time I try

Is there a way this can be resolved, please?

I tried using SQL server Management Studio to add new tables, trying to add new stored procedures I see red lines in my stored procedure, indicating "Invalid object..........". example

CREATE PROCEDURE [dbo].[CertificateRecipient]
	 @CreatedBy VARCHAR(50)
	,@PageIndex INT
	,@PageSize INT
	,@RecordCount INT OUT

AS
	BEGIN
    SELECT ROW_NUMBER() OVER(ORDER BY Id DESC) RowNumber
	        ,Id
			,email
			,CreatedBy
			,CreatedDate
			,Recipient
			,RecEmail
			,Reference
    INTO #Temp 
    FROM DocumentTable
	WHERE CreatedBy = @CreatedBy ORDER BY Id DESC

	SELECT @RecordCount = COUNT(*) FROM #Temp

	SELECT * FROM #Temp
    WHERE (RowNumber BETWEEN ((@PageIndex-1) * @PageSize) + 1 AND (@PageIndex * @PageSize)) OR @PageIndex = - 1 ORDER BY Id DESC
   
    DROP TABLE #Temp 

	END

Red lines under table name "DocumentTable", and columns

Answer 1

Thanks for posting your question in the Microsoft Q&A forum.
I found this error when using "Server Explorer" instead of "SQL Server Object Explorer" to add new tables.

** Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful **

Answer 2

I have decided to use SQL Server Management Studio for this and it is working. Thank you everyone for your answers. I really appreciate