Recently I encountered this issue. Customer was trying to install SMO by using the following switch in the setup command line for SQL 2008: /FEATURES=SNAC_SDK However, the installation didn’t cache the SMO dll’s in the c:\program files\Microsoft SQL Server\100\SDK\Assemblies folder – as suggested in the below article: Installing SMO http://msdn.microsoft.com/en-us/library/ms162189.aspx However, these dlls are cached in GAC (Global Cache Assembly) c:\windows\assembly. He wanted to know how to cache these assemblies in to the c:\program files\Microsoft SQL Server\100\SDK\Assemblies folder I tried reproducing this issue. Installed the below features: · Client Tools Connectivity · Client Tools Backward Compatibility · Client Tools SDK · SQL Client Connectivity SDK · BIDS Still the Assemblies folder was not getting created under c:\program files\Microsoft SQL Server\100\SDK\ folder. Later, installing the SMO from the Management Feature pack helped populate the assembly cache. The Feature pack is available at http://www.microsoft.com/downloads/details.aspx?familyid=B33D2C78-1059-4CE2-B80D-2343C099BCB4&displaylang=en Venkatraghavan SE, SQL support Reviewed by: Nickson Dicson & Shamik Ghosh TL, SQL support
Recently I encountered this issue. Customer was trying to install SMO by using the following switch in the setup command line for SQL 2008:
/FEATURES=SNAC_SDK
However, the installation didn’t cache the SMO dll’s in the c:\program files\Microsoft SQL Server\100\SDK\Assemblies folder – as suggested in the below article:
Installing SMO http://msdn.microsoft.com/en-us/library/ms162189.aspx
However, these dlls are cached in GAC (Global Cache Assembly) c:\windows\assembly.
He wanted to know how to cache these assemblies in to the c:\program files\Microsoft SQL Server\100\SDK\Assemblies folder
I tried reproducing this issue. Installed the below features:
· Client Tools Connectivity
· Client Tools Backward Compatibility
· Client Tools SDK
· SQL Client Connectivity SDK
· BIDS
Still the Assemblies folder was not getting created under c:\program files\Microsoft SQL Server\100\SDK\ folder.
Later, installing the SMO from the Management Feature pack helped populate the assembly cache.
The Feature pack is available at http://www.microsoft.com/downloads/details.aspx?familyid=B33D2C78-1059-4CE2-B80D-2343C099BCB4&displaylang=en
Venkatraghavan
SE, SQL support
Reviewed by:
Nickson Dicson & Shamik Ghosh
TL, SQL support
nice blog and information about Installing Client tools for SQL 2008 doesn’t populate the SMO in the SQL Assemblies folder and <a href="www.datasparc.com/ms-sql-server-client-tools.html"> microsoft sql server client tools </a>.