|
|
Posted by Erland Sommarskog on 07/12/06 22:08
R.A.M. (r_ahimsa_m@poczta.onet.pl) writes:
> I tried adding references to Microsoft.SqlServer.ConnectionInfo and
> Microsoft.SqlServer.Smo - and I could build assembly. But then I
> cannot create assembly in SQL Server:
>
> "An exception occured while executing a Transact statement or batch
> (Microsoft.SqlServer.Express.ConnectionInfo).
> Assembly 'microsoft.sqlserver.smo, version=9.0.242.0, culture=neutral,
> publictoken=89845dcd8080cc91.' was not found in the SQL catalog.
> (Microsoft SQL Server, Error: 6503)"
>
> Could you help me to solve it...
There is a smaller set of .Net Fx assemblies that are loaded by default
in SQL Server. Apparently Microsoft.SqlServer.Smo is not one of them.
You could create an assembly in your database for the DLL with CREATE
ASSEMBLY, but I suspect that there is a reason why this DLL is not
loaded. I don't think the intention is that SMO is to be called from
within SQL Server. (But I have stayed away from SMO, so I don't really
know for sure.)
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|