Bize Ulaşın / Contact Us

Virtual Center Veritabaninin Collation degerini degistirmek.

16 / 02 / 2011 by Uncategorized Yorum yok / No Comments

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.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">

*

Kontrol / Control * Time limit is exhausted. Please reload CAPTCHA.