|
select
t.name,
s.name as [Schema],
[ParentObjectName] = isnull(o.name,'' ),
[ParentObjectSchema] = isnull(OBJECT_SCHEMA_NAME(o.object_id),''),
t.parent_class,
t.object_id,
t.is_disabled,
t.is_not_for_replication,
t.is_instead_of_trigger,
am.assembly_class,
am.assembly_method,
a.name as [AssemblyName],
dp.name as [ExecuteAs],
IsAfter = cast(IsNull(ObjectProperty(t.object_id,'ExecIsAfterTrigger'),'0')as bit)
from sys.triggers t join sys.assembly_modules am on t.object_id=am.object_id
join sys.assemblies a on a.assembly_id = am.assembly_id
left join sys.objects o on o.object_id = t.parent_id
left join sys.database_principals dp on am.execute_as_principal_id=dp.principal_id
join sys.schemas s on s.schema_id = o.schema_id
where t.type='TA'
select object_id,type_desc from sys.trigger_events;
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
My name is Robert Kanasz and I have been working with ASP.NET, WinForms and C# for several years.
MCSD - Web Applications
MCSE - Data Platform
MCPD - ASP.NET Developer 3.5
- Web Developer 4
MCITP - Database Administrator 2008
- Database Developer 2008
MCSA - SQL Server 2012
MCTS - .NET Framework 3.5, ASP.NET Applications
- SQL Server 2008, Database Development
- SQL Server 2008, Implementation and Maintenance
- .NET Framework 4, Data Access
- .NET Framework 4, Service Communication Applications
- .NET Framework 4, Web Applications
MS - Programming in HTML5 with JavaScript and CSS3 Specialist
Open source projects:
DBScripter - Library for scripting SQL Server database objects
Please, do not forget vote