Any special care for CLR code when moving to other servers

I am pretty certain that once you create an assembly referring to a dll on
one server, and i decide to move that database to another server, the
assembly goes with it as part of the database and I dont have to recreate
the assembly or move the dll to the other server.. am i right ?Yes, you are right, the assembly is part of the database, even if you move
the database to another database server.
Also notice that by default on SQL Server CLR Integration is disabled so you
may need to enable it first.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Hassan" wrote:
> I am pretty certain that once you create an assembly referring to a dll on
> one server, and i decide to move that database to another server, the
> assembly goes with it as part of the database and I dont have to recreate
> the assembly or move the dll to the other server.. am i right ?
>
>