Changing collation of Virtual Center Database

Changing collation of Virtual Center Database


I needed to change VMWare ESXs Virtual Center 2 Database collation while moving the DB to another MS SQL server using different collation, you might not need to change VC2 DB collation but I think it is better to use default server collation. As usual for most databases I got the error below; because of an object dependent on database collation.

  • 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)
You can easily deal with this issue by using the steps below.
  1. After restoring the DB on target server , browse to VC2 DBProgrammabilityFunctionsTable-valued Functions, right click on sys_PhysicalIndexStatistics_Wrapper then select Script Function As > Create To > New Query Editor, it will create the query needed to re-create the  sys_PhysicalIndexStatistics_Wrapper object.
  2. Delete sys_PhysicalIndexStatistics_Wrapper
  3. Change collation of the database.
  4. Run the query you have created on step 1. , check if sys_PhysicalIndexStatistics_Wrapper created successfully.


visit link download

Popular posts from this blog

IP2Location IP Country ISP Database April 2013 Torrent Download

Image
IP2Location IP Country ISP Database April 2013 Torrent Download Download Torrent IP2Location IP-Country-ISP Database Database IP2Location IP-COUNTRY-ISP enables solution to determine the location and Internet Service Provider (ISP) or the company of any IP address in a few steps simple. First, retrieve IP address from changing the protocol or server-side network web server. Next, translate IP address to IP number in decimal format to speed up database query. Lastly, reverse lookup the IP number from the IP2Location database to show the exact geographical location. Seeds: 108 Peers: 63 Requires: Microsoft Excel Size: 12 mb Files: 2 Developer: Hexa Software Development Center Category: Network Tools|IP Tools Size: 12 MB visit link download
Read more

Change Your IMEI in Android Mobile

Image
Change Your IMEI in Android Mobile                              In Android Cell phone, in some cases your IMEI give you mistake. So with this technique you can quickly change or fix your Android Cell phone IMEI number With IMEI Changer The original post is on Earn Money Online Android Tips And Tricks download Moded Apk © copyright, 2016 Androidapp9.tk Best Regards! visit link download
Read more

Cerpen Evelyn Waugh Penumpang yang Simpatik

Image
Cerpen Evelyn Waugh Penumpang yang Simpatik Penumpang yang Simpatik Oleh EVELYN WAUGH Terjemahan Muhammad Rihardja Ketika Tuan James baru menutup daun pintu yang telah ditinggalkan beberapa langkah di belakangnya, musik dari sebuah pesawat radio langsung meledak-ledak keluar dari semua jendela yang ada di rumahnya itu. Agnes, yang sedang berada di dapur lah yang menghidupkan pesawat radio dengan lantunan sebuah lagu itu. Sementara istrinya, Nyonya James, sedang mandi di kamar mandi. Beberapa program acara yang sebentar-sebentar berganti-ganti, terus terdengar, mengikuti langkah Tuan James menuju ke garasi hingga mobil mulai melaju menuju jalan kecil di depan rumah. Dia menyetir sejauh dua belas mil ke arah stasiun, dan dalam perjalanan sejauh lima mil pertama, ia masih dalam suasana hati yang gundah. Sebenarnya ketika menghadapi setiap masalah, Tuan James adalah tipe laki-laki yang selalu menampilkan sifatnya yang lembut. Tapi sayangnya tidak dalam satu hal. Dia akan berubah menjadi ka...
Read more