Change Collation Settings for an Entire SQL Server 2000 Database (VB.NET)
Version Compatibility: Visual Basic.NET, ASP.NET
Please refer to the notes for a few issues. In particular, note that you will need sysadmin privileges on the SQL Server in order to do this, and that the change won't work on every single column, so you may want to log the columns where it doesn't work (not done here) in order to change those columns manually later.
Instructions: Copy the declarations and code below and paste directly into your VB project.