Hi Robert,
Based on my understanding, I think the problem is that the new installed Visual Studio 2008 may break some assemblies of Sql Server 2005. You need to check whether the “Microsoft.SqlServer.Types�assemble is located in the correct place. The path of this assemble in my computer is “C:\Program Files (x86)\Microsoft SQL Server\100\SDK\Assemblies\Microsoft.SqlServer.Types.dll� The path of the assemble in your computer may be a little different.
If you couldn’t find the assemble, I think you need to reinstall the Sql Server 2005. Another way is to download the dll and locate it in the correct place.
If you could find it, you need to add that as a reference to your project.
Let me know if this helps.
Aland Li
Please mark the replies as answers if they help and unmark if they don't. This can be beneficial to other community members reading the thread.