What is the syntax for creating a new assembly in SQL Server 2005?
CREATE ASSEMBLY assembly_name
[ AUTHORIZATION owner_name ]
FROM { <client_assembly_specifier> | <assembly_bits> [ ,...n ] }
[ WITH PERMISSION_SET = { SAFE | EXTERNAL_ACCESS | UNSAFE } ]
[ ; ]
What is the syntax for creating a new assembly in SQL Server 2005?
Assemblies can be created using CREATE ASSEMBLY command. It takes the path of the DLL as the parameter.
Example:CREATE DIRECTORY Sample
FROM ‘\\sampleserver\CodeLib\Mysample.dll’
When the CREATE ASSEMBLY is executed, the DLL is copied to master database.
