Connection with SQL Server 2008

Nov 28, 2008 at 6:08 PM
I can't connect with SS2008. It works only with 2005?
Thanks
Feb 18, 2009 at 8:01 PM
Edited Feb 18, 2009 at 8:02 PM
DDC is using 2005 assemblies. If you can compile the source replace the Microsoft.SqlServer.* references in the project file(DataDictionaryCreator.csproj) with the 2008 ones e.g.
<
Reference Include="Microsoft.SqlServer.ConnectionInfo, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91, processorArchitecture=MSIL" />
<
Reference Include="Microsoft.SqlServer.Management.Sdk.Sfc, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91, processorArchitecture=MSIL" />
<
Reference Include="Microsoft.SqlServer.Smo, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91, processorArchitecture=MSIL" />

 

 

 

 

Mar 26, 2009 at 10:21 AM
Edited Mar 26, 2009 at 10:21 AM
Sorry ~
i can't run DDC  in SQL2008   (with Server2008)
SQL connection error ~
because sql command
----------------
    SELECT DISTINCT s.name
    FROM INFORMATION_SCHEMA.COLUMNS i_s
    INNER JOIN sysproperties s ON s.id = OBJECT_ID(i_s.TABLE_SCHEMA+'.'+i_s.TABLE_NAME) AND s.smallid = i_s.ORDINAL_POSITION AND s.name != 'MS_Description'
    WHERE OBJECTPROPERTY(OBJECT_ID(i_s.TABLE_SCHEMA+'.'+i_s.TABLE_NAME), 'IsMsShipped')=0
---------------
it' Error :Message is "Invalid object name 'sysproperties'"

how  to  fix it  ??
thanks~~


Mar 27, 2009 at 2:57 AM
I Find  a Solution to fix this problem ~
Should to modify this file : "read_previous_properties.sql"
change it's IF block condition ~~