April 29, 2008 at 2:01 pm
I am new to this and I am trying to write a script that deletes a stored procedures and the assembly. First I need to check that the procedures and assemby exist before I delete them. Here is what I have but it doesn't seem to work:
use AP
if assemblyproperty ('GetTop10Vendors', 'SimpleName') is not null
begin
drop proc GetTop10Vendors
drop assembly GetTop10Vendors
end
any ideas as to what I could be doing wrong?
April 29, 2008 at 2:49 pm
what error do you get?
Assuming the objects are actually out there - that code looks like it would work....
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply