Why does my CLR function keep disappearing <p>I am a rookie to SQL and here is my questions.</p> <p>I have some CLR sql functions and procedures. When I deploy the 1st one, everything is fine. But after the 2nd one deployed, the first one will disappear.</p> <p>Anyone can help me out?</p> <p>Thanks a lot </p> <hr> <p>Actually, I simply create a new SQL project in VS, adding a new function or stored procedure, click deploy, and I can see the new function in my SQL instance. Then I close that project and open a new one, repeat the above steps, OK, the 2nd function is there i my instance but the 1st one disappeared or be replaced and no longer queryable for use.</p> <hr> <p>Thank you for your reply.</p> <p>All these clr functions and procedures are in the same instance of the database.</p>