Table Ownership

[klewis10367]

I created a table with the owner as dbo. For specific reasons I needed to change the table owner to an NT Group. However the users in the Group that is now the owner of the table cannot design the table. The design option is greyed out. Any ideas why? Or is there something I am missing. We are using SQL 2000 . The funny thing is that another user in the same group can modify the table using the SQL 2005 Management Studio.

 

[mrdenny]

It's possible that it's an issue with the SQL 2000 Client Tools. Have the user that it's not working for log onto the machine with SQL 2005 installed and try it from there.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[klewis10367]

That's what they are going to try next. One question, does it matter that I had indexes on the tables that were created in the dbo name?

 

[mrdenny]

No, when the table is moved to the new schema the indexes follow it.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com