Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mavershang
Posting Yak Master
111 Posts |
 Posted - 2010-01-19 : 16:44:26
|
| 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.Here is how I did it: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 but the 1st one disappeared or be replaced. All these clr functions and procedures are in the same instance of the database.Anyone can help me out?Thanks a lot |
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2010-01-20 : 00:59:58
|
| Are you dropping and recreating the same assembly name? You can deploy many clr objects from single project. |
 |
|
|
|
|
|
why does my SQL CLR function keep disappearing?