October 8, 2002 at 9:53 am
Curious this one but we have a db which is 21Gb and there seems to be duplicated from the scheme tables. For example we have a table named 'stock' with the owner being scheme and also there is a 'stock' table with the owner of dbo! What I would like to find out is a) are they used and can I trace the actions that are associated with it? and b) what are the implications if I delete these, or alternatively DTS them somewhere else temporarily? If I DTS them can I re-import them easily enough?
Thanks
October 8, 2002 at 10:04 am
This is allowed, most likely someone logged in as "scheme" and created the table and someone also created the table as "dbo".
You would have to check your application or use Profiler to monitor traffic and see if there is any access.
I'd send emails through your company first and get negative responses before deleting anything.
Steve Jones
October 31, 2002 at 3:10 am
This is a known problem when using roles, so use sp_addalias to give somebody dbo rights
Cheers,
Prakash
Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA
October 31, 2002 at 8:40 am
I wouldn't recommend using aliases; they are a deprecated feature and discouraged by Microsoft. Instead, I would limit the number of people who have privileges to create objects and educate them in the use of fully-qualified object naming (e.g. "CREATE TABLE dbo.myTable") as a means of ensuring that their objects are properly owned by "dbo."
Matthew Burr
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply