~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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 PROTECTED]
