Does v9 support both "ALTER" & "If exists .. DROP + CREATE"?

[vehro]

Get MS to change how it handles the issue to begin with. Support for "create or replace" (instead of separate create x and alter x) would not only address your issue directly, but would also solve the issue of the dropped permissions that occur for

if exists('procedure x') drop procedure x
go
create procedure x...

[Barry K]

I have run into this issue on numerous occasions. We have functions that call themselves recursively. If you add a parameter to the function that calls itself, simply doing an alter function will not work because it will give you an error that "the procedure or function has too many arguments specified".

If you drop and create the function, it will create it properly.

[David Atkinson]

The latest 9.5 Beta has options to add existence checks and DROP/CREATE.

More details here:
http://www.red-gate.com/MessageBoard/viewtopic.php?t=14113

Please give it a go and let us know if this meets your requirements.

David Atkinson
Product Manager
Red Gate Software

[David Atkinson]

The latest 9.5 Beta has options to add existence checks and DROP/CREATE.

More details here:
http://www.red-gate.com/MessageBoard/viewtopic.php?t=14113

Please give it a go and let us know if this meets your requirements.

David Atkinson
Product Manager
Red Gate Software