Feb 12, 2014

Assembly '' was not found in the SQL catalog of database ''. Msg 15135, Level 16, State 8, Procedure sp_addextendedproperty, Line 37 Object is invalid. Extended properties are not permitted on '', or the object does not exist. Msg 15135, Level 16, State 8, Procedure sp_addextendedproperty, Line 37 Object is invalid. Extended properties are not permitted on '', or the object does not exist.


When we will try to create a CLR objects CLR stored procedure of data types we may get error message like:

Assembly '' was not found in the SQL catalog of database ''.
Msg 15135, Level 16, State 8, Procedure sp_addextendedproperty, Line 37
Object is invalid. Extended properties are not permitted on '', or the object does not exist.
Msg 15135, Level 16, State 8, Procedure sp_addextendedproperty, Line 37
Object is invalid. Extended properties are not permitted on '', or the object does not exist.

Cause:

You have not created the assembly of your CLR object.

Solution:

First create the assembly of you CLR stored procedures or data types. For this go through the following link:

No comments:

Post a Comment