I've jut created a new table in a SQL Server 2008 database. I'm trying to write a stored procedure to insert data into this new table. One of the cool features I like in SQL 2008 is the intellisence built into the T-SQL designer. Anyway, when I type INSERT INTO then the Intellisense drop down doesn't present me with my new table. Even if I type in the name of the new table the the T-SQL designer gives me an error of "invalid object". I have made sure that the permissions on the new table and any of the other old tables is identical, but only the old tables appear in the designer.
OK, so what's wrong?