Modify the Owner of the SQL2000 data table for DBO

xiaoxiao2021-03-06  42

The laboratory's database is moved from the main server to the branch server. It uses a copy database MDF, LDF file, an additional database, and the additional data sheet Owner is still the owner name on the head office server, but the user does not log in. Unable to log in from the client, after logging in with other users, you must query the data in Select * from ownernam.tablename, without modifying the software, you have to change the data table Owner. Use master go sp_configure 'allow updates', 0Reconfigure with override go use labgo

Update sysobjects set uid = 1 where uid = 5gouse master go sp_configure 'allow updates', 0Reconfigure with override go // personal storage, no reproduced!

转载请注明原文地址:https://www.9cbs.com/read-71579.html

New Post(0)