批量更改mssql表用户为系统默认用户的SQL语句

打开企业管理器->工具->SQL 查询分析器

执行以下SQL就可以批量更改mssql表用户为系统默认用户了

1. declare tb cursor local for
   
2. select 'sp_changeobjectowner ''['+replace(user_name(uid),']',']]')+'].['
   
3. +replace(name,']',']]')+']'',''dbo'''
   
4. from sysobjects
   
5. where xtype in('U','V','P','TR','FN','IF','TF') and status>=0
   
6. open tb
   
7. declare @s nvarchar(4000)
   
8. fetch tb into @s
   
9. while @@fetch_status=0
   
10. begin
    
11. exec(@s)
    
12. fetch tb into @s
    
13. end
    
14. close tb
    
15. deallocate tb
    
16. go

复制代码