use EnVisage

go  
--NotificationType  System=0
--NotificationType  Task=1
--NotificationType  Workflow=2
--NotificationType  User=3
--NotificationType  Error=4

--HowtoSend		Web=0
--HowtoSend		Email=1
--HowtoSend		Text=2

delete from NotificationControl where NotificationType=1 and HowtoSend=0
delete from NotificationControl where NotificationType=4 and HowtoSend=0
delete from NotificationControl where NotificationType=4 and HowtoSend=1

-- send notifications to the client (web) for tasks
Insert into NotificationControl (Id,NotificationType,HowtoSend) values(NEWID(),1,0)
-- send notifications to the client (web) for errors
Insert into NotificationControl (Id,NotificationType,HowtoSend) values(NEWID(),4,0)

-- send notifications to the client (email) for errors
Insert into NotificationControl (Id,NotificationType,HowtoSend) values(NEWID(),4,1)