February 11, 2009 at 9:35 am
I have a table and stored procedure that exist (I can query the table and execute the procedure), but for some reason they are not appearing in the object explorer.
Has anyone run across this type of problem before and if so, is there away to get my seemingly invisible objects to re-appear?
February 11, 2009 at 10:31 am
Two possibilities come to mind. First, there's some sort of security issue, the object is in a different schema which you don't have access to, but the TSQL is logged in with a different login that does. Second, that you have a filter in SSMS that's preventing you from seeing the object.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 11, 2009 at 10:46 am
Filter was my first thought too, but there isn't one on...
And even the security I thought was a possibility as well (even though I'm using a login that has access to any and everything)...but upon that suggestion, I even went into the securables area to specifically add the table, just in case, but it's not even listed in browse for objects pop-up...:ermm:
February 11, 2009 at 11:05 am
How about a refresh? Was it created recently?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 11, 2009 at 11:07 am
I've tried several refreshes...it was created about a month ago now.
February 11, 2009 at 11:34 am
OK. I'm stuck. I assume you've run a consistency check? Can you query the table through the INFORMATION_SCHEMA.TABLE view?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 11, 2009 at 11:43 am
Eureka! Thanks for the tip about using INFORMATION_SCHEMA.TABLES (didn't know there was such a thing as I'm mostly a data-mole)...
Despite it having the TBL_ prefix my company likes tables to use, it is in actuality a view...sheer brilliance and not all confusion inducing...
Thanks again for letting me on the system view though!
February 11, 2009 at 11:52 am
Nice to know you figured it out. Thanks.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply