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.
Thanks, Jim |-----Original Message----- |From: Ken Schaefer [mailto:[EMAIL PROTECTED]] |Sent: Sunday, September 01, 2002 9:45 PM |To: ActiveServerPages |Subject: Re: SQL related question | | |Everything is/must be "owned" by a login. | |It's a bit like a file created on an NTFS partition - the file is owned by |the "creator", who has full control over the file. | |Do you just want to hide "dbo" for visual purposes? Do you want it owned by |a different login? What exactly are you trying to accomplish? | |Cheers |Ken | |~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |From: "Jim MacDiarmid" <[EMAIL PROTECTED]> |Subject: OT: SQL related question | | |: Dear List members, |: |: I have a user on my SQL server for the sole purpose of accessing |: the web database. For example, lets call it "MyWebDBUser". When |I create a |: view with this user, the SQL query which is generated has |: dbo.<tablename/viewname>.columnname in it. How can I find out how |: automatically leave off the dbo? It already appears that the user is a |: dbowner. Can someone point me in the right direction? Is there |a place in |: the help documentation I should look at? |: |: Thanks in advance!! | |~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ | | |--- |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]
