Can SQL 2005 load assembly from GAC?

CREATE ASSEMBLy seems to be able to load assembly from physical path only.There are a bunch of assemblies that are loaded from GAC automatically by
SQL Server, but user defined assemblies are registered into the database
from a path or binary bits only.
--
HTH,
SriSamp
Email: srisamp@.gmail.com
Blog: http://blogs.sqlxml.org/srinivassampath
URL: http://www32.brinkster.com/srisamp
"ffee" <ffee@.discussions.microsoft.com> wrote in message
news:6A027912-4859-42FA-BE57-D47AAD2F3D59@.microsoft.com...
> CREATE ASSEMBLy seems to be able to load assembly from physical path only.|||To add on to SriSamp's response, the assemblies are stored in the database
so that the database is portable. This allows the database to be restored
to a different server without assembly dependency issues.
Hope this helps.
Dan Guzman
SQL Server MVP
"ffee" <ffee@.discussions.microsoft.com> wrote in message
news:6A027912-4859-42FA-BE57-D47AAD2F3D59@.microsoft.com...
> CREATE ASSEMBLy seems to be able to load assembly from physical path only.