2

I created some objects in MS SQL Server 2008 using SubSonic 3. It created them based on the user specified in connection string like:

test_user.table1

but for some reason I am not able to test_user account. Now I am not able to access the tables within test_user schema. Is there any way to transfer schema from test_user to dbo so that any login can access it?

TheVillageIdiot
  • 297
  • 1
  • 4
  • 8

1 Answers1

3

ALTER AUTHORIZATION ON test_user.table1 TO dbo

OR

ALTER SCHEMA dbo TRANSFER test_user.table1

The older sp_changeobjectowner is deprecated

Some FYI: SQL: transfer database schema

Community
  • 1
gbn
  • 70,237
  • 8
  • 167
  • 244