Restore SQL 2K DB on SQL 2K5

[grwagner]

Hi,

our application is working with SQL authentication.

Normal setup: db name:spx_db, dbowner=tableowner:spx_db.

Restoring this database as test_db and changing dbowner=tableowner to test_db was no problem with SQL 2K.

But SQL2K5 has the new feature "schema". How can I assign a new "owner" of the database and replace the existing tableowner spx_db by test_db?

I have tried the description of "Troubleshooting orphaned users" in BOL of SQL 2K5 but it does not work.

The new login gets access to the database but is not replacing the existing tableowner.

Any suggestions?

Thankx in advance

Guenter Wagner

[rmiao]

Try create schema test_db and link spx_db to that schema.

[grwagner]

Great help!!!! Using ALTER SCHEMA schema_name TRANSFER object_name has changed the tableowner like we need it.