If any error occurs in the above process like:

Server: Msg 325, Level 15, State 1, Procedure Object Name, Line 4 Incorrect syntax near 'external'. You may need to set the compatibility level of the current database to a higher value to enable this feature.

Then we have to set the compatibility level to 90 from 80, which is default, before we create a CLR object in the database.

Listing 4

EXEC sp_dbcmptlevel 'DatabaseName',90