(note that I load the assemblies with version 10.0.0 which is the version of SQL server 2008 I have installed on my system) Here is a PowerShell script that uses SQL Server Management Objects (SMO) to do this task: I have a database that I want to change the collation of all its non system columns to "Arabic_CS_AS". What's good about this scenario is that Ubuntu's memory usage is light and gives a good space to host virtual machines.Ĭhanging a SQL serve database columns collations manually can be a tedious task. I installed the 64 bit edition of Linux Ubuntu 9.04 and can host Windows 2008 64bit OS using Virtual Box. Personally, I have a core 2 Due Laptop with Vista 32 bit installed. And if in doubt and want to run SharePoint on a virtual machine, check VMWare's tool that tests if your processor is capable of running a 64bit guest OS. If you have a core 2 due processor, it supports 64 bit. One important thing, SharePoint 2010 will no run on 32Bit machines. On Microsoft's SharePoint 2010 site, you can find tutorials, videos and you can register for the beta. My colleague Mourad Askar posted on his blog about SharePoint 2010 Information and Tutorials which I find very informative. SharePoint 2010 is coming with a lot of new features and if you are seriously interested in SharePoint, you should start build your 2010's knowledge.
0 Comments
Leave a Reply. |