Click here to Skip to main content
15,867,870 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I have created a table in desired database and inserted the data and can select the table too..
But when i move cursor on the table name its showing invalid object name.

SQL
USE [dEHSIM01]
GO

/****** Object:  Table [dbo].[t_remainder_mailing_list]    Script Date: 03/21/2013 14:49:33 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[t_remainder_mailing_list](
    [module] [varchar](50) NOT NULL,
    [task] [varchar](50) NOT NULL,
    [mail_from] [varchar](30) NOT NULL,
    [mail_to] [varchar](100) NOT NULL,
    [mail_cc] [varchar](100) NULL,
    [mail_bcc] [varchar](100) NULL,
    [mail_subject] [varchar](75) NULL,
    [textbody] [varchar](500) NULL,
    [attachment_path] [varchar](100) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO
Posted
Updated 20-Mar-13 23:22pm
v3
Comments
Zoltán Zörgő 21-Mar-13 5:10am    
export the database DDL to a script and post here.

Show ur coding if possible
 
Share this answer
 
Comments
gvprabu 21-Mar-13 5:21am    
If you are asking any Question, Use "Have a Question or Comments ? " Option. Don't Post your Questions and Clarifications in Solution area
Hi...
You are using SQL Server 2008 Right. U need to Refresh Local Cache... Do the following Steps in your Management Studio

Edit -> IntelliSense -> Refresh Local Cache

then check your table name

:-)

Regards,
GVPrabu
 
Share this answer
 
v2
Comments
Biodude Basava 21-Mar-13 5:24am    
Thanks a lot @gvprabu :):) Its working now
gvprabu 21-Mar-13 5:33am    
welcome... While asking questions give some more explanation about your actual Problem....
Enjoy a day... :-)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900