October 6, 2009 at 12:20 pm
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.
October 6, 2009 at 12:50 pm
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