db owner

My customer upsized his Access database tables. Then we linked the Access
front end to the SQL server. But instead of seeing the tables named
dbo_Customer and dbo_Orders we are seeing timothyl_Customer and
timothyl_Orders.
Obviously, he was not a member of the system administrators when he created
the tables, so he is the owner. But now my stored procedures, etc., which
refer to dbo.Customer do not work!
How can I fix this so that I can get back to dbo.filename?COnsider using SP_Changeobjectowner to change the owner of the objects.
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"menacher" <menacher@.discussions.microsoft.com> schrieb im Newsbeitrag
news:DCB21288-FAC2-40FA-9F56-9D9A4AC818FF@.microsoft.com...
> My customer upsized his Access database tables. Then we linked the Access
> front end to the SQL server. But instead of seeing the tables named
> dbo_Customer and dbo_Orders we are seeing timothyl_Customer and
> timothyl_Orders.
> Obviously, he was not a member of the system administrators when he
> created
> the tables, so he is the owner. But now my stored procedures, etc., which
> refer to dbo.Customer do not work!
> How can I fix this so that I can get back to dbo.filename?|||Would you agree that the syntax should read
exec sp_changeobjectowner 'timothyl.customer', 'sa'
I assume that the owner 'sa' (the built in administrator) is the proper
owner?
Viele dank.
"Jens Sü�meyer" wrote:
> COnsider using SP_Changeobjectowner to change the owner of the objects.
> --
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "menacher" <menacher@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:DCB21288-FAC2-40FA-9F56-9D9A4AC818FF@.microsoft.com...
> > My customer upsized his Access database tables. Then we linked the Access
> > front end to the SQL server. But instead of seeing the tables named
> > dbo_Customer and dbo_Orders we are seeing timothyl_Customer and
> > timothyl_Orders.
> >
> > Obviously, he was not a member of the system administrators when he
> > created
> > the tables, so he is the owner. But now my stored procedures, etc., which
> > refer to dbo.Customer do not work!
> >
> > How can I fix this so that I can get back to dbo.filename?
>
>|||(Viele dank. --> Cool, but its "Vielen Dank", just for your personal
knowledge no to be a peapicker ;-) )
No, it should read exec sp_changeobjectowner 'timothyl.customer', 'dbo'
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"menacher" <menacher@.discussions.microsoft.com> schrieb im Newsbeitrag
news:8F5E8126-09DC-4E3E-AA30-5C8EE0ABDDC5@.microsoft.com...
> Would you agree that the syntax should read
> exec sp_changeobjectowner 'timothyl.customer', 'sa'
> I assume that the owner 'sa' (the built in administrator) is the proper
> owner?
> Viele dank.
> "Jens Süßmeyer" wrote:
>> COnsider using SP_Changeobjectowner to change the owner of the objects.
>> --
>> HTH, Jens Suessmeyer.
>> --
>> http://www.sqlserver2005.de
>> --
>> "menacher" <menacher@.discussions.microsoft.com> schrieb im Newsbeitrag
>> news:DCB21288-FAC2-40FA-9F56-9D9A4AC818FF@.microsoft.com...
>> > My customer upsized his Access database tables. Then we linked the
>> > Access
>> > front end to the SQL server. But instead of seeing the tables named
>> > dbo_Customer and dbo_Orders we are seeing timothyl_Customer and
>> > timothyl_Orders.
>> >
>> > Obviously, he was not a member of the system administrators when he
>> > created
>> > the tables, so he is the owner. But now my stored procedures, etc.,
>> > which
>> > refer to dbo.Customer do not work!
>> >
>> > How can I fix this so that I can get back to dbo.filename?
>>