James Barash
james at fcidms.com
Fri Apr 5 08:25:21 CDT 2013
Liz: Thanks, I never knew that. I just refreshed the tables and assumed that would update the Intellisense. James Barash -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Elizabeth.J.Doering at wellsfargo.com Sent: Wednesday, April 03, 2013 7:48 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] Invalid Object name, SQL 2012 In SSMS Edit-->Intellisense-->Refresh Local Cache Should fix it right up. Maddening however, that it doesn't just refresh itself at intervals. Liz This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Paul Hartland Sent: Wednesday, April 03, 2013 1:54 PM To: Discussion concerning MS SQL Server Subject: Re: [dba-SQLServer] Invalid Object name, SQL 2012 Ah it just needed refreshing then, what I got into the habit of was if I created a new table in a database, before I done anything else I would right click the tables branch (as I call it) under my database and click refresh to refresh all tables. On 3 April 2013 19:49, David McAfee <davidmcafee at gmail.com> wrote: > Yes, it was. > > > On Wed, Apr 3, 2013 at 11:36 AM, Paul Hartland < > paul.hartland at googlemail.com > > wrote: > > > I would assume that that table was the last one you created > > > > > > On 3 April 2013 19:23, David McAfee <davidmcafee at gmail.com> wrote: > > > > > Yup that was it. I closed the stp and reopened it and I was still > seeing > > > the red lines. > > > > > > I closed all of my SSMS windows and reopened SSMS and it was opened. > > > > > > How weird that only one table was giving me the false error. > > > > > > Thanks, > > > David > > > > > > > > > > > > On Wed, Apr 3, 2013 at 10:52 AM, James Barash <james at fcidms.com> > wrote: > > > > > > > David: > > > > > > > > I see that all the time. It's some sort of bug in Management Studio. > If > > > > you create a table and then create a stored procedure without > > > > closing Management Studio, you will get the Invalid Object > > > > message. As long > as > > > the > > > > query runs, there won't be any problems. > > > > Once you close and reopen Management Studio, everything will be fine. > > At > > > > least that has been my experience. > > > > > > > > James Barash > > > > > > > > -----Original Message----- > > > > From: dba-sqlserver-bounces at databaseadvisors.com [mailto: > > > > dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of David > McAfee > > > > Sent: Wednesday, April 03, 2013 1:15 PM > > > > To: Discussion concerning MS SQL Server > > > > Subject: [dba-SQLServer] Invalid Object name, SQL 2012 > > > > > > > > Have any of you come across this error? > > > > > > > > I am running a local instance of SQL 2012 on my box. > > > > I created a few tables and I am now creating a stored procedure. > > > > > > > > In the procedure, I get a red underline under one of the table names. > > > > > > > > When I mouse over the red underline, it displays: "Invalid > > > > object > name > > > > 'tblTerritoryRsmJunct'" > > > > > > > > The select statement DOES work and return the correct values. > > > > > > > > > > > > SELECT > > > > R.RegionDesc, > > > > GSM.Fullname AS GSM, > > > > RSM.Fullname AS RSM, > > > > T.Territory, > > > > T.TerrID AS TerritoryID > > > > FROM tblRegion R (NOLOCK) > > > > INNER JOIN tblUser GSM (NOLOCK) ON R.GsmUserGuid = GSM.UserGuid > > > > INNER JOIN tblTerritory T (NOLOCK) ON T.RegionID = R.RegionID > > > > INNER JOIN (SELECT TerritoryID, MAX(entryDate) as MaxDate > > > > FROM tblTerritoryRsmJunct (NOLOCK) > > > > WHERE entryDate < @AsOfDate > > > > GROUP BY TerritoryID) AS RJ1 ON T.TerrID = > > > > RJ1.territoryid > > > > INNER JOIN tblRouteSellerJunct AS RJ2 (NOLOCK) > > > > ON RJ1.territoryID = RJ2.TerritoryID > > > > AND RJ1.MaxDate = RJ2.entryDate > > > > INNER JOIN tblUser RSM (NOLOCK) ON RSM.UserGuid = RJ2.RsmGuid > > > > > > > > > > > > I've even dragged in the table name from the Object explorer so > > > > it > > reads: > > > > [dbo].[tblRouteSellerJunct] but it still underlines it in red. > > > > > > > > The file name is 20 characters long. I've named tables with > > > > longer > > names > > > > before. > > > > > > > > Any ideas? > > > > > > > > Thanks, > > > > David > > > > _______________________________________________ > > > > dba-SQLServer mailing list > > > > dba-SQLServer at databaseadvisors.com > > > > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > > > > http://www.databaseadvisors.com > > > > > > > > > > > > > > > > > > > > _______________________________________________ > > > > dba-SQLServer mailing list > > > > dba-SQLServer at databaseadvisors.com > > > > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > > > > http://www.databaseadvisors.com > > > > > > > > > > > _______________________________________________ > > > dba-SQLServer mailing list > > > dba-SQLServer at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > > > http://www.databaseadvisors.com > > > > > > > > > > > > -- > > Paul Hartland > > paul.hartland at googlemail.com > > _______________________________________________ > > dba-SQLServer mailing list > > dba-SQLServer at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > > http://www.databaseadvisors.com > > > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > > -- Paul Hartland paul.hartland at googlemail.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com