Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-Server-2008
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.
 
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 20-Mar-13 23:34pm
Edited 21-Mar-13 0:22am
v3
Comments
Zoltán Zörgő at 21-Mar-13 5:10am
   
export the database DDL to a script and post here.
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Show ur coding if possible
  Permalink  
Comments
gvprabu at 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
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

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
 
Smile | :)
 
Regards,
GVPrabu
  Permalink  
v2
Comments
Biodude Basava at 21-Mar-13 5:24am
   
Thanks a lot @gvprabu :):) Its working now
gvprabu at 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)

  Print Answers RSS
0 OriginalGriff 304
1 Sergey Alexandrovich Kryukov 255
2 Shweta N Mishra 216
3 Maciej Los 210
4 PIEBALDconsult 184
0 OriginalGriff 7,660
1 Sergey Alexandrovich Kryukov 7,072
2 DamithSL 5,586
3 Manas Bhardwaj 4,946
4 Maciej Los 4,665


Advertise | Privacy | Mobile
Web04 | 2.8.1411023.1 | Last Updated 21 Mar 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100