How do I change the owner of a table? - Support Queries

Welcome Guest

Search | Active Topics | Members | Log In | Register

myLittleTools Community Forum » myLittleAdmin for SQL Server 2000 » Support Queries » How do I change the owner of a table?

How do I change the owner of a table?

Options · View

Previous Topic · Next Topic

OM2

Posted: Sunday, November 15, 2009 2:38:19 AM

Rank: Newbie
Groups: Member

Joined: 11/15/2009
Posts: 2
Points: 6

I'm with 1and1 and have V2.7 myLittleAdmin

I've copied over a DB from another hosting account also on 1and1

One of the tables for some reason has the owner as being the previous database

Question: how can I change the owner of a table using myLittleAdmin?

Thanks

OM

elian

Posted: Monday, November 16, 2009 8:58:06 AM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France

I think that you're talking about schema and not owner.
Here is a nice article which explains how to do that:
http://bit.ly/4oHkDM

Users browsing this topic

Guest

myLittleTools Community Forum » myLittleAdmin for SQL Server 2000 » Support Queries » How do I change the owner of a table?

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.