如何把"用户定义的数据类型"的ower改为dbo?

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

方法1.先删除,再重新建立
 ifexists(select*fromdbo.systypeswherename=N'dt_ac_area')
 execsp_droptypeN'ssn'
 GO
 setuser--默认是dbo
 GO
 EXECsp_addtypeN'dt_ac_area',N'char(3)',N'notnull'
 GO

 方法2.直接通过全部山删除SRX的UserDefinedDataTypes:
 USEmaster
 go
 EXECsp_configure'allowupdates','1'
 go
 RECONFIGUREWITHOVERRIDE
 go
 uset--databasename
 go
 begintransaction
 deletesystypeswhereuid=user_id('srx')
 if@@rowcount<>0
  committransaction
 else
  rollbacktransaction
 go
 usemaster
 go
 EXECsp_configure'allowupdates','1'
 go
 RECONFIGUREWITHOVERRIDE
 go


还忘记一点，如果你不想删除，你可以用第二种方法直接更新为dbo：

 USEmaster
 go
 EXECsp_configure'allowupdates','1'
 go
 RECONFIGUREWITHOVERRIDE
 go
 uset--databasename
 go
 begintransaction
 UPDATEsystypesSETUID=1whereuid=user_id('srx')--直接更新
 if@@rowcount<>0
  committransaction
 else
  rollbacktransaction
 go
 usemaster
 go
 EXECsp_configure'allowupdates','1'
 go
 RECONFIGUREWITHOVERRIDE
 go

 

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>