Problem with tables and objects created in SQL Server 2008

  • I need to move a database from SQL 2000 Server 2000 to a SQL 2008 Server.

    So, just for a laugh, I backed up a SQL 2000 database and restored it using SQL Server 2008 Management Studio on the 2008 Server.

    Everthing seemed to work okay, so I started to carry on developing. Using SQL Server 2008 Management Studio, I created a table like this:

    CREATE TABLE [dbo].[TAGenericStage](

    [GenericStageID] [int] IDENTITY(1,1) NOT NULL,

    [ActionID] [int] NOT NULL,

    [ACID] [int] NOT NULL,

    [StageName] [varchar](100) NULL

    ) ON [PRIMARY]

    I refreshed the list of tables and it appeared in the list. I opened the table and added a few rows of data.

    I started to write a stored procedure to return data from the new table. The procedure included this ...

    SELECT TAGenericStage.StageName FROM TAGenericStage

    ... As I was typing - as soon as I typed 'Select T' - intellisense appeared and showed me a list of all the tables in the database starting with 'T' - but not the one I have just created.

    In the stored procedure the name of the table is underlined in red. If I mouse over it says 'Invalid object'.

    I finished the stored procedure and executed it like this:

    USE [ContactsDevelopment2008]

    GO

    DECLARE@return_value int

    EXEC@return_value = [dbo].[TAGenericStageDetails_List] 1

    SELECT'Return Value' = @return_value

    GO

    It executes the stored procedure and shows the results. But, the name of the stored procedure ... '[dbo].[TAGenericStageDetails_List]' is underlined in red. If I mouseover it says 'Cannot find stored procedure'

    How can a stored procedure that can't be found be executed?

    What do I have to do so that my new objects are 'seen' properly?

    Thanks for any help.

  • Found the answer - Edit | Intellisense | Refresh Local Cache - did the trick.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply