Why does my CLR function keep disappearing
- by user208080
Hi there. I am a rookie to SQL and here is my questions.
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.
Anyone can help me out?
Thanks a lot
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.
Thank you for your reply.
All these clr functions and procedures are in the same instance of the database.