July 1, 2005 at 1:18 am
HI Folks
I have situtation where owner of objects such as tables, store procedures etc.. change from dbo to another user name which exist in the database.. (e.g. william)
It is happening when i backup database and restore straight from backup i have made..
I need to know that why this happening and how.. Please anyone could explain me in detail..
Thanx in advance
SqlIndia
July 1, 2005 at 8:30 am
Backup and restore does not change any object owners. There must be something else at work.
July 4, 2005 at 12:16 am
Could you provide more detail, preferably the exact steps that you take. Are you restoring to the same server? Are you using the standard built-in SQL backups?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply