Whose the owner??

Question

Whose the owner??

S Hodkinson

SSCertifiable

Points: 7529
More actions
May 11, 2006 at 4:12 am

#114231

We have a database where the owner was originally 'sa' and we needed to change it to 'cfrmisadm' (this user has all the fixed server roles). We tried detaching and re-attaching as 'cfrmisadm'; no luck.
We then ran 'sp_changedbowner' which reported success. The login also shows as dbo on the database.
However the taskpad in EM continues to show that 'sa' is the owner; users can still access the database as can 'cfrmisadm'.
So why won't taskpad show 'cfrmisam' as the owner?? Its has been refreshed endlessly and we have tried shutting down EM and re-connecting to the server again but it will not show the correct owner.
Madame Artois

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Yelena Varshal SSC-Dedicated Points: 34286 More actions · Answer 1

If you did disconnect and re-connect with your EM than make sure you are connecting to the correct database or correct server. This is NOT a joke, this is from the experience. Please, also query Master database "select SID,dbid,name from sysdatabases" and see what is SID. If it is 0x01 than it is SA who is your owner, if it is a long number, than it is a user's SID

Regards,Yelena Varsha

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 2

You might need to trace EM and see what it is pulling. I suspect there might be a big somewhere or it is pulling from another location, like the original owner.

S Hodkinson SSCertifiable Points: 7529 More actions · Answer 3

"You might need to trace EM and see what it is pulling. I suspect there might be a big somewhere or it is pulling from another location, like the original owner."

Sorry but I don't understand you.

Do you mean SQL Profiler for the trace? I only know how to do this for a database so I'll have to have a look.

I don't understand 'big somewhere' or 'pulling from another location'

Madame Artois

S Hodkinson SSCertifiable Points: 7529 More actions · Answer 4

We are connecting to the right server and database so I'll try looking in master db. This a 3rd party database where we have repeated trouble with the logins and permissions. Its the only one where we do have trouble so we are beginning to think that its something within the programming of the application

Madame Artois

S Hodkinson SSCertifiable Points: 7529 More actions · Answer 5

I have run the above script and find that 'cfrmisadm' is the owner. The curious thing is that this morning, when I logged into EM, that the owner has changed to 'cfrmisadm' in EM Taskpad.

That has got to be a bit weird........... Why did EM Taskpad take so long to refresh with the right owner?

Madame Artois

R2ro Default port Points: 1439 More actions · Answer 6

EM doesn't typically refresh. Manually refreshing the current view is a habit to which one should become addicted.

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 7

Agreed. When changing the owner, you'll have to force the refresh. Otherwise the Taskpad view doesn't go back and pull the updated information.

K. Brian Kelley
@kbriankelley