David McAfee
davidmcafee at gmail.com
Wed Apr 3 13:23:22 CDT 2013
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 > >