March 17, 2011 at 5:08 pm
What will be the impact if the used database owner login got disable.
..In my orgnization one person created Database with his login but now he has left the orgnization.Please tell me if we will disable his login.
It was windows login.'
After disabling the login ,Databse will work properly ?
Need help...Please reply soon...Its urgent.....
Thanks in advance.
March 18, 2011 at 7:42 am
It should make no difference. However if that is listed as the owner of any jobs in the database they may start failing. Being the actual Database Owner however should have no impact. To clean up the reference though you can easily change it.
USE master
GO
ALTER AUTHORIZATION ON Database::myDB TO [sa]
GO
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
March 23, 2011 at 5:01 am
Thank you
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply