Yes. That's the way it is. Tore.
-----Original Message----- From: Jim MacDiarmid [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 03, 2002 8:53 AM To: ActiveServerPages Subject: RE: SQL related question I understand what you're saying, however, when in my current situation when creating a view in the Enterprise Manager, SQL will automatically preface the object with the current owner name or "dbo". If I remove it, when I go to save the view, SQL will re-add the owner name. Thanks again, Jim |-----Original Message----- |From: Ken Schaefer [mailto:[EMAIL PROTECTED]] |Sent: Monday, September 02, 2002 10:28 PM |To: ActiveServerPages |Subject: Re: SQL related question | | |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.unsub%% | --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
