Virtual Center Veritabaninin Collation degerini degistirmek.

Az once VMWare ESX in Virtual Center 2 Database ini fakli collation'a sahip bir SQL sunucusuna tasirken, ne olur ne olmaz belki bir uyumluluk sorunu cikartir diye veritabaninin Collation'i ni Latin1_General_CP1_CI_AS 'den SQL_Latin1_General_CP1_CI_AS 'e cevirmem gerekti fakat cogu veritabaninda karsilasilmasi dogal olan hatalardan birini aldim

• Alter failed for Database 'VirtualCenter2'.  (Microsoft.SqlServer.Smo)
• An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
• The object 'sys_PhysicalIndexStatistics_Wrapper' is dependent on database collation. The database collation cannot be changed if a schema-bound object depends on it. Remove the dependencies on the database collation and then retry the operation.
• ALTER DATABASE failed. The default collation of database 'VirtualCenter2' cannot be set to SQL_Latin1_General_CP1_CI_AS. (.Net SqlClient Data Provider) (Microsoft SQL Server, Error: 5075)

Bu hatayi sizde asmak isterseniz asagidaki basit adimlardan faydalanabilirsiniz. (4 adim)

1. Database i hedef SQL sunucusuna restore ettikten sonra, DB\Programmability\Functions\Table-valued Functions altindaki sys_PhysicalIndexStatistics_Wrapper'a sag tusla basip Script Function As > Create To > New Query Editor u secin, sys_PhysicalIndexStatistics_Wrapper i yaratmak icin gerekli Query i boylece yedege almis olacaksiniz.
2. sys_PhysicalIndexStatistics_Wrapper objesini silin
3. Database collation i degistirin
4. 1. adimda acmis oldugunuz Query'i calistirin, sys_PhysicalIndexStatistics_Wrapper in yeniden yaratilmis oldugunu teyit edin.