Thank you for the guidance.

Hi,

Thank you very much for your response.The following Script worked absolutely fine.

Declare @OldOwner varchar(100), @NewOwner varchar(100)

set @OldOwner = 'dbo'

...

Hi,

Thank you both for taking your time to answer my question. I could able to successfully change the table owner using the sp_changeobjectowner '[currentschema].[currenttable]' , 'dbo' command. Now I have...

Hi All,

Thank you all for your suggestions on database backup. I can successfully do the database backup on weekly basis. I scheduled the batch file in the windows task scheduler....