When you create a query you do not need to use the fully qualified name *if* the object is owned by the user running the query -or- the object is owned by dbo
When you run a query that references an unqualified object SQL Server will attempt to see if there are any objects owned by the current user with that name, and if not, will attempt to see if there are any objects owned by dbo that have that name. Only if there are no objects owned by either will it bomb with an object not found error message. So, if a table, or sproc or whatever is owned by dbo, you don't need to put that in when writing your query. Cheers Ken ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ From: "Jim MacDiarmid" <[EMAIL PROTECTED]> Subject: RE: SQL related question : I don't want to "get rid" of it literally, I just didn't want it showing up : in the query : since it makes it confusing and hard to read. I know from working with SQL : 7, that when the user : created a Database, or Object in the Database, it would belong to that user, : and show their name : unless you did something to that user or to the database or to the object, : but I can't remember what it was. : I just remember that the "dbo" or the user's name did not preface the table : or object name once : something was changed. Sorry if this doesn't make any sense. : : Thanks for any assistance you can give on this, : Jim ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
