Urgent Regarding Users And Objects

i need to change the object owner from actuate to dbo

i wrote this script which will give me an execute process which i just need to run on query analyser it works fine for object owner change from dbo to new user but gives an error saying the object does not exist when i want to change it from user actuate to dbo...can some one correct me in this regard..here is the script.


Select "Exec sp_changeobjectowner", + name + ",dbo"
From sysobjects
Where type = "P" and
uid = 6 order by name

uid i found from sysusers table

it gives me some thing like this

Result : Exec sp_changeobjectowner MonthlyPerformanceSummary_Occupancy,dbo

This works the other way around

Exec sp_changeobjectowner MonthlyPerformanceSummary_Occupancy,kavitha

error: object does not exist


And the other issue is i have certain stored procedures for which i need to give permission exec for a specific user, i did create the user...what shold i do to grant exec privilage to this user..for all the stored procedures at a time finding the stored procedure name.

its like this the name always starts with sp_actuate...does this help in finding the stored procedure and then granting the exec privilage.

Thanks a lot in advance.


Kavitha