How can I detect the availability of sp_addextendedproperty on sql server

Question

How can I find out if sp_addextendedproperty is available before trying to use it in a sql script?

I gather it's not available on Azure.

(I'm working on this bug, if you're interested).

Also you say I don't want to just detect that it is azure in case microsft add/remove this proc from various versions of sql server in the future. Why not just not use extended properties in the first place? — Aaron Bertrand, Commented Apr 26, 2015 at 15:48

Dan Guzman · Accepted Answer · 2015-04-25 23:22:08Z

4

Use OBJECT_ID to see of the object exists. The function will return NULL if not:

IF OBJECT_ID(N'sp_addextendedproperty', 'P') IS NOT NULL
    EXEC sp_addextendedproperty ...

answered Apr 25, 2015 at 23:22

Dan Guzman

28.3k2 gold badges45 silver badges69 bronze badges

Add a comment |

1 Answer 1