现在的位置: 首页 > 综合 > 正文

SQL 2005 Beta2 和VS 2005 Beta1安装的问题

2012年12月07日 ⁄ 综合 ⁄ 共 1939字 ⁄ 字号 评论关闭
总的来说没有大的问题,目前两个版本是我喜欢的比较稳定的版本,专家们的一些信息,都验证过的-确如此,搜集下来,勿留言讨论Download的问题

SQL Server 2005 Installation
So the party has begun - SQL Server 2005 is released, as many out in the blog-sphere has already reported. And Whidbey (excuse me Visual studio 2005) Beta 1 is also released.

 
You may notice that the CLR versions of VS and SQL2K5 are different. VS is 40607.16 whereas SQL2K5 is .42. This can have consequences when installing the stuff. To be on the safe side, install SQL2K5 first followed by VS. That way the latest CLR (.42) will be installed, which SQL2K5 requires, and VS will play just nicely with this build. If you however already have installed VS, then SQL will complain about not having the right CLR version. If this is the case, un-install the CLR and then install SQL, followed by VS.
 
 
The SQL Express version that shipped with Visual Studio Beta 1 is not Beta 2. I've already discovered one difference; SQL Express can use “FOR XML” with user-defined-type columns, in Beta 2 this produces an “unsupported” error message. There is a newer version of SQL Express released on MSDN subscriptions...or install the Developer's Edition of Beta 2.
http://staff.develop.com/bobb/weblog/PermaLink.aspx?guid=f18435fb-a6e2-4cb8-a86b-7e2c05bb2746
 
sqlaccess.dll is the in-database .NET data provider, System.Data.SqlServer. If you do any data access in .NET stored procedures, UDFs, triggers, UDTs, and UDAggregates, you are using this provider.
 
There is a version in Visual Studio Beta 1 (in \Program Files\Microsoft Visual Studio 8\Common7\IDE\PublicAssemblies) that (I think) Visual Studio uses in its Database projects. There's a different version (the size is different by 1k) in \Microsoft SQL Server\MSSQL.1\MSSQL\binn.
 
I've renamed Visual Studio's version to sqlaccess_vs.dll and copied SQL Server's version to the VS PublicAssemblies directory. I'm not exactly sure what's different yet, but am suspicious because the PublicAssemblies directory also contains ClrCppModule.dll. In SQLServer 2005 Beta 2, this piece is no longer needed to run CLR items in SQL Server.
 

抱歉!评论已关闭.