I am hoping that this question isn't something that I have
just overlooked but it deals with the owner of stored
procedures generated by vb.net.

Our developers login to our SQL Server machine as
themselves.  When they go to try to create stored
procedures using the "wizard" in .NET it always sets the
current user as the owner of the object.  We would
obviously like to have all objects in the database set to
the dbo.  How can I do this?!

Thanks in advance.

Dave Harper

Dave, I think if the user creating the object is already marked as a DBOwner
in the SQL DB that all objects created by them will be owned by DBO and not
the user.

If the user is not a DBOwner in the DB it would be a security hole to allow
the object to be owned by DBO as this would allow a not DBOwner to create a
bogus/malicious object that another DBOwner may accidentally make use of.

Cameron McColl[MS]
--
This posting is provided "AS IS" with no warranties, and confers no rights.