How to change the Owner of a User-Defined Data Type That Is in Use in SQL Server 2000?
Top : General Technical Support : Microsoft SQL Server
| Article ID: |
 |
000077 |
| Rating: |
|
0.0 / 5.0 (0 votes)
|
| Views: |
|
3502 |
|
|
How to change the Owner of a User-Defined Data Type That Is in Use in SQL Server 2000?
|
You can use the method from Microsft http://support.microsoft.com/default.aspx?scid=kb;en-us;Q327123 But it is not easy. Here is an easy way to do it.
Exec sp_configure 'Allow Update', 1
Reconfigure WITH OVERRIDE
Update systypes set uid = user_id('dbo') Where name = 'your_type_name'
Exec sp_configure 'Allow Update', 0
Reconfigure WITH OVERRIDE
|
