MSSQL – Selecting from objects listed from sp_help and getting “invalid object name”

Earlier this week I was looking up some tables in SSMS via alt+f1 (the sp_help command) and got invalid object. It was baffling me for several minutes until I looked in object explorer and had a different scheme name.

Goes to show you that the Owner value isn’t always the same as scheme, of course that makes sense as they are 2 different things: owner is more so for security and scheme is a separate location or container for db objects  🙂

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s