Share via

CREATE NOTIFICATION IF NOT EXIIST

Igor Korot 51 Reputation points
2025-01-25T03:34:34.7833333+00:00

Hi, ALL,

Is there a way to do thttps://learn.microsoft.com/en-us/sql/t-sql/statements/create-event-notification-transact-sql?view=sql-server-ver16 if one do not exist?

Thank you,

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,418 questions
Accepted answer
  1. Erland Sommarskog 116.2K Reputation points MVP
    2025-01-25T19:26:30.63+00:00 
    IF NOT EXISTS (SELECT * FROM sys.event_notifications WHERE name = 'MyEventNot')
    CREATE EVENT NOTIFICATION MyEventNot ON ...
    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.