Trigger: uMobiEmployeeTrg Trigger: uMobiEmployeeTrg| Property | Value |
|---|---|
| Trigger | uMobiEmployeeTrg |
| ID | 2068202418 |
| Owner | dbo |
| Schema | dbo |
| For Object | vMobiEmployee |
| Disabled |
|
| Is Not For Replication |
|
| Trigger Type Description | SQL TRIGGER |
| ANSI NULLS |
|
| QUOTED IDENTIFIER |
|
| Encrypted |
|
| MS Shipped |
|
| Execute As | Caller |
| Modify Date | 11/26/2011 3:26:16 PM |
| Creation Date | 11/26/2011 3:26:16 PM |
| Name | Value |
|---|---|
| MS_Description | mobi czwartek uMobiEmployeeTrg |
| Is After Trigger | Is Instead Of | Insert Trigger | Update Trigger | Delete Trigger |
|---|---|---|---|---|
|
|
|
|
|
|
| First Delete Trigger | First Insert Trigger | First Update Trigger | Last Delete Trigger | Last Insert Trigger | Last Update Trigger |
|---|---|---|---|---|---|
|
|
|
|
|
|
|
| Script |
|---|
| SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON create trigger [dbo].[uMobiEmployeeTrg] on [dbo].[vMobiEmployee] instead of update as print 'x' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'mobi czwartek uMobiEmployeeTrg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vMobiEmployee', @level2type=N'TRIGGER',@level2name=N'uMobiEmployeeTrg' |