CODEWITHSUNDEEP
sql-server
Phillip Senn
Phillip Senn

Reputation: 47595

Why is the word "Event" highlighted in blue in ssms?

I don't see it as a reserved word, so why does ssms highlight in blue? I can 

create table event

but it's disconcerting if it's highlighted in blue.

Upvotes: 2

Views: 213

Answers (2)

Dave Mason
Dave Mason

Reputation: 4936

SQL Server has EVENT NOTIFICATIONs, which are a special kind of database object that sends information about server and database events to a Service Broker service. It's kind of like an asynchronous trigger.

Here's a blog post that shows how to use an EVENT NOTIFICATION to alert when a database has been backed up or restored.

Also, Colleen Morrow has many great articles about SERVICE BROKER on her blog.

Upvotes: 2

gofr1
gofr1

Reputation: 15977

I think it is related with (CREATE, ALTER, DROP) EVENT SESSION. You can read on MSDN about this stuff (this works since SQL Server 2008).

Upvotes: 3

Related Questions