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 |-----Original Message----- |From: Ken Schaefer [mailto:[EMAIL PROTECTED]] |Sent: Monday, September 02, 2002 9:50 PM |To: ActiveServerPages |Subject: Re: SQL related question | | |~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |From: "Jim MacDiarmid" <[EMAIL PROTECTED]> |Subject: RE: SQL related question | | |: I just want to hide the "dbo" preface on the table name. I read in the |help |: file on how to change the db owner and Object owner witht the stored |: procedures "sp_ChangedbOwner" and "sp_ChangeObjectOwner", respectively. |: However, when I go to update the SQL queries in the View's, it adds the |new |: owner preface to the table name. |: I'm just looking to get rid or hide the owner portion. | |~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ | |As I said, everything needs to be "owned" by someone. You can't |"get rid" of |it. It's a critical part of any security infrastructure. As an |example, look |at the way NTFS works - there is always a creater/owner assigned to each |file. You can take ownership of a file, but you can't "get rid" of |ownership |altogether. | |As I asked before - why are you trying to do this? What are trying to |accomplish? (maybe we can suggest something alternative) | |Cheers |Ken | | |--- |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]
