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